{"text_format":"1","workbook":"xlsx","n_sheets":75,"sheets":["Data Summary","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71","72","73","74"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Summary","index":0,"n_rows":78,"n_cols":1,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["Report Name"]
["Table 1 : SEBI Registered Market Intermediaries/Market Infrastructure Institutions"]
["Table 2 : Company-wise Capital Raised through Public and Rights Issues (Equity) during the month"]
["Table 3 :  Open Offers Closed under SAST Regulations (during the month)"]
["Table 4 : Substantial Acquisition of Shares and Takeovers"]
["Table 5 : Capital Raised from the Primary Market through  Public and Rights Issues"]
["Table 6 : Issues Listed on SME Platform"]
["Table 7 : Industry-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Table 8 : Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues (Equity)"]
["Table 9 : Size-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Table 10 : Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Table 11 : Preferential Allotments Listed at Stock Exchanges"]
["Table 12 : Private Placement of Corporate Debt Reported to Stock Exchanges"]
["Table 13 : Trading in the Corporate Debt Market"]
["Table 14 : Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 15 : Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 16 : Distribution of Turnover on Cash Segments of Stock Exchanges  (₹crore)"]
["Table 17 : Trends in Cash Segment of BSE"]
["Table 18 : Trends in Cash Segment of NSE"]
["Table 19 : Trends in Cash Segment of MSEI"]
["Table 20 : City-wise Distribution of Turnover on Cash Segment of Exchanges "]
["Table 21 : Category-wise Share of Turnover in Cash Segment of BSE"]
["Table 22 : Category-wise Share of Turnover in Cash Segment of NSE"]
["Table 23 : Category-wise Share of Turnover in Cash Segment of MSEI"]
["Table 24 : Component Stocks: S&P BSE Sensex "]
["Table 25 : Component Stocks: Nifty 50 Index "]
["Table 26 : Component Stocks: SX40 Index during   "]
["Table 27 : Advances/Declines in Cash Segment of Exchanges"]
["Table 28 : Trading Frequency in Cash Segment of of Exchanges"]
["Table 29 : Daily Volatility of Major Indices  "]
["Table 30 : Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment of Exchanges "]
["Table 31 : Settlement Statistics for Cash Segment of ICCL"]
["Table 32 : Settlement Statistics for Cash Segment of NCL"]
["Table 33 : Settlement Statistics for Cash Segment of MCCIL"]
["Table 34 : Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value)"]
["Table 35 : Trends in Equity Derivatives Segment at NSE (Turnover in Notional Value)"]
["Table 36 : Settlement Statistics in Equity Derivatives Segment "]
["Table 37 : Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Table 38 : Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Table 39 : Instrument-wise Turnover in Index Derivatives at BSE"]
["Table 40 : Instrument-wise Turnover in Index Derivatives at NSE"]
["Table 41 : Trends in Currency Derivatives Segment at BSE"]
["Table 42 : Trends in Currency Derivatives Segment at NSE"]
["Table 43 : Trends in Currency Derivatives Segment at MSEI"]
["Table 44 : Settlement Statistics of Currency Derivatives Segment "]
["Table 45 : Instrument-wise Turnover in Currency Derivative Segment of BSE"]
["Table 46 : Instrument-wise Turnover in Currency Derivatives of NSE"]
["Table 47 : Instrument-wise Turnover in Currency Derivative Segment of MSEI"]
["Table 48 : Maturity-wise Turnover in Currency Derivative Segment of BSE "]
["Table 49 : Maturity-wise Turnover in Currency Derivative Segment of NSE "]
["Table 50 : Maturity-wise Turnover in Currency Derivative Segment of MSEI "]
["Table 51 : Trading Statistics in Interest Rate Derivatives Segment"]
["Table 52 : Settlement Statistics in Interest Rate Derivatives Segment "]
["Table 53 : Trends in Foreign Portfolio Investment"]
["Table 54 : Notional Value of Offshore Derivative Instruments (ODIs) compared to Assets Under Custody (AUC) of FPIs/Deemed FPIs"]
["Table 55 : Assets under the Custody of Custodians"]
["Table 56 : Trends in Resource Mobilization by Mutual Funds"]
["Table 57 : Status of Mutual Funds Industry in India"]
["Table 58 : Trends in Transactions on Stock Exchanges by Mutual Funds"]
["Table 59 : Assets Managed by Portfolio Managers"]
["Table 60 : Progress Report of NSDL & CDSL for Listed Companies"]
["Table 61 : Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Table 62 : Depository Statistics "]
["Table 63 : Number of Commodities Permitted and Traded at Exchanges"]
["Table 64 : Trends in Commodity Indices"]
["Table 65 : Trends in Commodity Derivatives at MCX "]
["Table 66 : Trends in Commodity Derivatives at NCDEX"]
["Table 67 : Trends in Commodity Derivatives at ICEX"]
["Table 68 : Trends in Commodity Derivatives Segment at BSE"]
["Table 69 : Trends in Commodity Derivatives Segment at NSE"]
["Table 70 : Participant-wise percentage Share of Turnover in Commodity Derivatives at various Exchanges"]
["Table 71 : Commodity-wise Turnover and Trading Volume at MCX"]
["Table 72 : Commodity-wise Turnover and Trading Volume at NCDEX "]
["Table 73 : Commodity-wise Turnover and Trading Volume at ICEX, BSE and NSE"]
["Table 74 : Macro Economic Indicators"]
[]
[]
["Note- No. - Number"]

{"sheet":"1","index":1,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[40,0,40,1],[41,0,41,2],[43,0,43,1],[0,0,0,2],[39,0,39,1]]}
["Table 1: SEBI Recognised/Registered Intermediaries / Market Infrastructure Institutions"]
["Particular","2019-20","2020-21$"]
["Stock Exchanges ","9",7]
["      of that have:"]
["             Cash Segment #",3,3]
["             Equity Derivatives Segment #",3,3]
["            Currency Derivatives Segment#",3,3]
["            Commodity Derivatives Segment#",5,5]
["            International Exchange (IFSC)#%",2,0]
["Brokers (Cash Segment)",4249,4591]
["Brokers (Equity Derivatives Segment)",3460,3456]
["Brokers (Currency Derivatives Segment)",2708,2683]
["Brokers (Debt Segment)",378,415]
["Brokers (Commodity Derivatives Segment)",2257,2227]
["Corporate  Brokers(Cash Segment)",3231,3535]
["Foreign Portfolio Investors (FPIs)",9679,9846]
["Custodians",19,19]
["Depositories",2,2]
["Depository Participants (NSDL)",285,281]
["Depository Participants (CDSL)",614,611]
["Merchant Bankers",215,212]
["Bankers to an Issue",66,64]
["Underwriters",2,2]
["Debenture Trustees",31,29]
["Credit Rating Agencies",7,7]
["KYC Registration Agencies (KRA)",5,5]
["Registrars to an Issue & Share Transfer Agents",80,78]
["Venture Capital Funds",189,188]
["Foreign Venture Capital Investors",251,255]
["Alternative Investment Funds",649,706]
["Portfolio Managers",351,356]
["Mutual Funds",47,49]
["Investment Advisors",1291,1338]
["Research Analysts",680,705]
["Infrastructure Investment Trusts (InvITs)",10,11]
["Collective Investment Schemes",1,1]
["Approved Intermediaries (Stock Lending Schemes)",2,2]
["STP (Centralised Hub)",1,1]
["STP Service Providers",3,3]
["Notes:"]
["$ indicates as on November 30, 2020"]
["#% IFSC are now under regulatory jurisdiction of International Financial Services Centres Authority (IFSCA) w.e.f. October 01, 2020"]
["# SEBI has granted recognition for carrying out operations in the respective segment. "]
["Source: SEBI, NSDL."]

{"sheet":"2","index":2,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,9],[6,0,6,5],[9,0,9,5]]}
["Table 2: Company-wise Capital Raised through Public and Rights Issues (Equity) during the month"]
["Sl.No.","Name of the Issuer/Company","Date of Listing","Type of Issue","Type of Instrument","No. of Shares Issued","Face Value (₹   )","Premium Value (₹   )","Issue Price (₹   )","Size of Issue  ( ₹   crore)"]
[1,"Equitas Small Finance Bank Limited","2020-11-02","BSE/ NSE","Equity",156848484,10,{"$f":"I3-G3","v":23},33,517.6]
[2,"Gland Pharma Limited","2020-11-20","BSE/ NSE","Equity",43196968,1,{"$f":"I4-G4","v":1499},1500,6479.5451999999996]
[3,"Shine Fashions (India) Limited","2020-11-02","BSE SME IPO","Equity",399000,10,30,40,1.59]
[4,"Mold-Tek Packaging Limited***","2020-11-27","BSE/ NSE","Equity",{"$f":"555330+3331980","v":3887310},5,175,180,71.3]
["Notes: All the issues are compiled from the Prospectus of Issuer Companies filed with SEBI."]
["From April, 2020 onwards the data is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["***Shares issued by the Company are partly paid up but the information is provided considering the same as fully paid up & figures also includes 33,31,980 warrants issued under Rights Issue at the Issue Price of ₹184."]
["Source: SEBI."]

{"sheet":"3","index":3,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,1],[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,2,7],[1,8,2,8]]}
["Table 3: Open Offers Closed under SAST Regulations (during November 2020)"]
["Sl.No","Target Company","Acquirer","Offer Opening Date","Offer Closing Date","Offer Size",null,"Offer  Price \n(₹   ) per share","Offer Size \n ( ₹   crore)"]
[null,null,null,null,null,"No. of \nShares","as per cent of Equity \nCapital"]
["Nil","Nil","Nil","Nil","Nil","Nil","Nil","Nil","Nil"]
["Source: SEBI."]

{"sheet":"4","index":4,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,8],[16,0,16,8],[0,0,0,8],[1,0,4,0],[1,1,1,8],[2,1,2,6],[2,7,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,4,7],[3,8,4,8]]}
["Table 4: Substantial Acquisition of Shares and Takeovers"]
["Year / Month"," Offers"]
[null,"Objectives",null,null,null,null,null,"Total"]
[null,"Change in Control \nof Management",null,"Consolidation of\n Holdings",null,"Substantial \nAcquisition",null,"No. of Offers","Amount  \n( ₹   crore)"]
[null,"No. of Offers","Amount  \n( ₹   crore)","No. of Offers","Amount  \n( ₹   crore)","No. of Offers","Amount  \n( ₹   crore)"]
["2019-20",49,16401.64,4,3641.83,3,478.38,56,20521.849999999999]
["2020-21$",{"$f":"SUM(B8:B15)","v":26},{"$f":"SUM(C8:C15)","v":8958.6},2,9.8699999999999992,2,4.08,30,8972.5499999999993]
["Apr-20",2,1.36,1,2.36,0,0,3,3.72]
["May-20",0,0,0,0,0,0,0,0]
["Jun-20",4,1088.1099999999999,0,0,0,0,4,1088.1099999999999]
["Jul-20",2,528.16,0,0,0,0,2,528.16]
["Aug-20",7,3852.44,1,7.51,1,1.72,9,3861.67]
["2020-09-01",5,3008.03,0,0,1,2.36,{"$f":"B13+D13+F13","v":6},{"$f":"C13+E13+G13","v":3010.3900000000003}]
["2020-10-01",6,480.5,0,0,0,0,6,480.5]
["Nov-20",0,0,0,0,0,0,0,0]
["Note: $ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"5","index":5,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,15,1,16],[2,3,2,6],[2,7,2,10],[2,11,2,14],[2,15,4,15],[2,16,4,16],[3,13,3,14],[0,0,0,14],[1,0,4,0],[1,1,3,2],[1,3,1,14],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[16,0,16,14],[17,0,17,14],[18,0,18,14],[20,0,20,14],[19,0,19,2]]}
["Table 5:  Capital Raised from the Primary Market through  Public and Rights Issues "]
["Year / Month","Total (Equity + Debt)",null,"Equity Issue",null,null,null,null,null,null,null,null,null,null,null,"Debt Issue"]
[null,null,null,"Category-wise",null,null,null,"Issue-Type",null,null,null,"Instrument-wise",null,null,null,"No. of issues","Amount \n( ₹   crore)"]
[null,null,null,"Public",null,"Rights",null,"Listed",null,"IPOs",null,"At Par",null,"At Premium"]
[null,"No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)"]
["2019-20",{"$f":"D6+F6+P6","v":110},91948.935435799998,60,21322.873772599996,16,55642.041663199998,19,55679.271663200001,57,21285.65,2,8.74,74,76956.181663199983,34,14984.02]
["2020-21$",{"$f":"D7+F7+P7","v":55},94212.19075200001,{"$f":"SUM(D8:D15)","v":30},{"$f":"SUM(E8:E15)","v":29733.401274999997},15,60607.739477000003,16,75607.73947700001,29,14733.401274999998,0,0,45,90341.144451999993,10,3871.05]
["2020-04-01",4,116.31,3,13.92,0,0,0,0,3,13.92,0,0,3,13.92,1,102.39]
["2020-05-01",1,297.25,0,0,0,0,0,0,0,0,0,0,0,0,1,297.25]
["2020-06-01",{"$f":"D10+F10+P10","v":4},{"$f":"E10+G10+Q10","v":53448.84},1,2.46,1,53124.2,1,53124.2,1,2.46,0,0,2,{"$f":"E10+G10","v":53126.659999999996},2,322.18]
["2020-07-01",6,16070.569975000002,4,15510.779975000001,1,399.79,2,15399.79,3,510.77997499999998,0,0,5,15910.569975000002,1,160]
["2020-08-01",{"$f":"D12+F12+P12","v":9},6107.75,2,11.45,7,6096.3,7,6096.3,2,11.45,0,0,9,6107.75,0,0]
["2020-09-01",6,1821.2944770000001,3,1308.905,2,362.68947700000001,2,362.68947700000001,3,1308.905,0,0,5,1671.5944769999999,1,149.69999999999999]
["2020-10-01",20,9137.6062999999995,14,5887.1462999999985,3,553.46,3,553.46,14,5887.1462999999985,0,0,17,6440.61,3,{"$f":"300+397+2000","v":2697}]
["2020-11-01",{"$f":"D15+F15+P15","v":5},{"$f":"E15+G15+Q15","v":7212.57},3,6998.74,1,71.3,1,71.3,3,6998.74,0,0,4,7070.04,1,142.53]
["Notes:"]
["1. Equity public issues also includes issues listed on SME platform."]
["2. From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["3. The data of Debt is being prepared based on closing date."]
["$ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"6","index":6,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,2],[13,0,13,2],[14,0,14,2],[15,0,15,2]]}
["Table 6:  Issues Listed on SME Platform"]
["Year/Month","No. of issue","Amount \n( ₹   crore)"]
["2019-20",46,495.38279999999992]
["2020-21$",{"$f":"SUM(B5:B12)","v":18},{"$f":"SUM(C5:C12)","v":113.095}]
["2020-04-01",3,13.92]
["2020-05-01",0,0]
["2020-06-01",1,2.46]
["2020-07-01",2,14.53]
["2020-08-01",2,11.45]
["2020-09-01",1,6.8849999999999998]
["2020-10-01",8,62.26]
["2020-11-01",1,1.59]
["Notes -"]
["From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on November 30, 2020"]
["Source: SEBI"]

{"sheet":"7","index":7,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,0,29,6],[0,0,0,6],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[27,0,27,6]]}
["Table 7:  Industry-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Industry","2019-20",null,"2020-21$",null,"2020-11-01"]
[null,"No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)"]
["Airlines",0,0,0,0,0,0]
["Automobiles",0,0,0,0,0,0]
["Banks/FIs",3,2345.4762225000004,2,15119.896001999999,0,0]
["Cement/ Constructions",5,274.93637059999998,3,22.65,0,0]
["Chemical",4,152.65588200000002,3,993.17,0,0]
["Consumer Services",3,66.110399999999998,4,487.06,0,0]
["Electronic Equipments/ Products",5,4217.9735599999995,1,6.89,0,0]
["Engineering",5,1992.0974509999999,3,515.4,0,0]
["Entertainment",1,2.2692000000000001,2,303.49,0,0]
["Finance",3,10446.407567999999,4,5519.6,1,517.6]
["Food processing",2,64.08,0,0,0,0]
["Healthcare",7,4701.9486699999998,1,6479.55,1,6479.55]
["Hotels",0,0,1,349.66,0,0]
["Info Tech",4,484.00772219999999,6,1336.25,0,0]
["Misc",0,0,7,5044.24,1,71.3]
["Roads & Highways",0,0,1,4.55,0,0]
["Telecom",1,500,0,0,0,0]
["Textile",0,0,2,996.71,1,1.59]
["Plastic",2,8.9792000000000005,2,10.55,0,0]
["Power",0,0,0,0,0,0]
["Printing",3,49969.657650000001,1,2.4,0,0]
["Oil & Natural Gas",1,23.1576345,2,53149.07,0,0]
["Insurance",27,1715.1552454999999,0,0,0,0]
["Total",76,76964.912776300014,{"$f":"SUM(D4:D26)","v":45},90341.136002000014,{"$f":"SUM(F4:F26)","v":4},{"$f":"SUM(G4:G26)","v":7070.0400000000009}]
["Notes - From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"8","index":8,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,2],[0,0,0,11],[1,0,3,0],[1,1,2,2],[1,3,1,6],[1,7,1,16],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[14,0,14,11],[14,12,14,14],[15,0,15,2]]}
["Table 8:  Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues (Equity)"]
["Year / Month","Total",null,"Sector-wise",null,null,null,"Region-wise"]
[null,null,null,"Private",null,"Public",null,"Northern",null,"Eastern",null,"Western",null,"Southern",null,"Central"]
[null,"No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)"]
["2019-20",{"$f":"D5+F5","v":76},{"$f":"E5+G5","v":76964.921663200003},74,75849.851663199996,2,1115.0700000000002,17,39089.743609999998,0,0,51,34666.080000000002,8,3209.0995856999998,0,0]
["2020-21$",{"$f":"SUM(B7:B14)","v":45},{"$f":"SUM(C7:C14)","v":90341.144452000008},44,89897.454452000005,1,443.69,6,681.50947700000006,2,429.19000000000005,29,77639.604974999995,8,11590.84,0,0]
["2020-04-01",3,13.92,3,13.92,0,0,0,0,0,0,3,13.92,0,0,0,0]
["2020-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2020-06-01",2,{"$f":"E9+G9","v":53126.66},2,53126.66,0,0,0,0,0,0,2,53126.66,0,0,0,0]
["2020-07-01",5,15910.569975000002,5,15910.569975000002,0,0,2,14.53,0,0,3,15896.039975000002,0,0,0,0]
["2020-08-01",9,{"$f":"E11+G11","v":6107.75},9,6107.75,0,0,1,299.79000000000002,1,79.53,5,4211.37,2,1517.06,0,0]
["2020-09-01",5,1671.5944769999999,5,1671.5944769999999,0,0,2,362.68947700000001,0,0,2,606.88499999999999,1,702.02,0,0]
["2020-10-01",{"$f":"D13+F13","v":17},{"$f":"E13+G13","v":6440.61},16,5996.92,1,443.69,1,4.5,1,349.66,13,3783.14,2,2303.31,0,0]
["2020-11-01",{"$f":"D14+F14","v":4},{"$f":"E14+G14","v":7070.0400000000009},4,7070.0400000000009,0,0,0,0,0,0,1,1.59,3,7068.45,0,0]
["Notes - From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"9","index":9,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,14],[15,0,15,2],[0,0,0,13],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14]]}
["Table 9:  Size-wise Classification of Capital Raised through Public and Rights Issues (Equity)"]
["Year / Month","Total",null,"< ₹ 5 crore",null,"≥ ₹5crore - < ₹10crore",null,"  ≥₹ 10 crore - < ₹50 crore",null,"  ≥₹ 50 crore - < ₹100 crore",null,"  ≥ ₹100 crore - < ₹500 crore",null,">=₹500 crore"]
[null,"No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)","No. of issues","Amount \n( ₹   crore)"]
["2019-20",76,76964.911663199993,19,59.28,12,89.88,24,481.42686700000002,1,60,8,2606.6236902000001,12,73667.701105999993]
["2020-21$",{"$f":"SUM(B6:B13)","v":45},{"$f":"SUM(C6:C13)","v":90341.144974999988},10,36.340000000000003,4,30.154999999999998,6,96.35,3,212.03000000000003,10,2964.7699750000002,12,87001.5]
["2020-04-01",{"$f":"D6+H6+L6+N6+F6+J6","v":3},13.919999999999998,2,5.64,1,8.2799999999999994,0,0,0,0,0,0,0,0]
["2020-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2020-06-01",2,53126.659999999996,1,2.46,0,0,0,0,0,0,0,0,1,53124.2]
["2020-07-01",5,15910.569975,1,4.0199999999999996,0,0,1,10.51,0,0,2,896.03997500000003,1,15000]
["2020-08-01",9,6107.7499999999991,1,4.55,1,6.9,1,24.87,1,79.53,2,415.77,3,5576.13]
["2020-09-01",5,1671.595,0,0,1,6.8849999999999998,0,0,0,0,2,362.69,2,1302.02]
["2020-10-01",17,{"$f":"E12+I12+M12+O12+G12+K12","v":6440.61},4,18.079999999999998,1,8.09,4,60.97,1,61.2,4,1290.27,3,5002]
["2020-11-01",{"$f":"D13+H13+L13+N13+F13+J13","v":4},{"$f":"E13+I13+M13+O13+G13+K13","v":7070.04},1,1.59,0,0,0,0,1,71.3,0,0,2,6997.15]
["Notes - From April, 2020 onwards the data of equity is being prepared based on the listing date of the issues as against earlier practice of preparing it based on the closing date."]
["$ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"10","index":10,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,9,1,10],[14,0,14,8],[15,0,15,8],[16,0,16,8],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Year / Month","Only BSE",null,"Only NSE",null,"Only MSEI",null,"Both NSE and BSE",null,"Total"]
[null,"No. of issues","Amount (₹ crore)","No. of issues","Amount (₹crore)","No. of issues","Amount (₹crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)"]
["2019-20",0,0,0,0,0,0,14,54388.924919999998,14,54388.924919999998]
["2020-21$",{"$f":"SUM(B6:B13)","v":0},{"$f":"SUM(C6:C13)","v":0},0,0,0,0,17,56725.270000000004,17,56725.270000000004]
["Apr-20",0,0,0,0,0,0,0,0,0,0]
["May-20",0,0,0,0,0,0,0,0,0,0]
["Jun-20",0,0,0,0,0,0,2,8212.5,2,8212.5]
["Jul-20",0,0,0,0,0,0,1,2000,1,2000]
["Aug-20 *",0,0,0,0,0,0,7,42724.94,7,42724.94]
["2020-09-01",0,0,0,0,0,0,3,1337.87,3,1337.87]
["2020-10-01",0,0,0,0,0,0,3,2199.9699999999998,3,2199.9699999999998]
["2020-11-01",0,0,0,0,0,0,1,249.99,1,249.99]
["Notes -"]
["$ indicates as on November 30, 2020"]
["* In the month of August 2020, the common amount on BSE and NSE includes warrants of HDFC Ltd of ₹ 3,999.99 cr"]
["Source: BSE, NSE and MSEI."]

{"sheet":"11","index":11,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,1,18,3],[1,9,1,10],[0,0,0,8],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 11: Preferential Allotments Listed at Stock Exchanges"]
[null,"BSE@",null,"NSE@",null,"MSEI @",null,"Common#",null,"Total"]
["Year/ Month","No.of  issues","Amount (`crore)","No.of  issues","Amount (`crore)","No.of  issues","Amount (`crore)","No.of  issues","Amount (`crore)","No.of  issues","Amount (`crore)"]
[1,2,3,4,5,6,7,8,9,10,11]
["2019-20",128,1839.73,14,76.11,4,11.26,138,172959.34999999998,284,174886.46]
["2020-21$",{"$f":"SUM(B7:B14)","v":65},{"$f":"SUM(C7:C14)","v":634.24},7,50.760000000000005,3,7.8,70,25008.464022558997,{"$f":"SUM(J7:J14)","v":145},25701.26]
["Apr-20",14,117.45,0,0,0,0,8,988.95,22,1106.4000000000001]
["May-20",4,11.14,0,0,0,0,7,295.88,11,307.02]
["Jun-20",10,64.959999999999994,0,0,0,0,8,3967.7,18,4032.66]
["Jul-20",9,83.64,0,0,0,0,9,798.85,18,882.49]
["Aug-20",10,101.04,2,9,0,0,6,2626.62,18,2736.66]
["2020-09-01",7,43.41,2,10.46,0,0,11,7621.09,20,7674.96]
["2020-10-01",5,63.09,2,30.099999999999998,3,7.8,15,1851.2940225590003,25,1952.28]
["2020-11-01",6,149.51,1,1.2,0,0,6,6858.08,13,7008.79]
["Notes :"]
["1. @ The issues are exclusively listed on respective exchanges."]
["2. # The issues listed on 'any two' or 'all three' exchanges."]
["$ indicates as on November 30, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"12","index":12,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,1],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 12: Private Placement of Corporate Debt Reported to Stock Exchanges"]
["Year/Month","Listed only on NSE",null,"Listed only on BSE",null,"Listed both Both NSE and BSE",null,"TOTAL"]
[null,"No. of Issues","Amount (₹crore)","No. of Issues","Amount (₹ crore)","No. of Issues","Amount (₹ crore)","No. of Issues","Amount (₹crore)"]
["2019-20",363,203066.26,1272,254976.4,152,216660.39,1787,674702.88]
["2020-21$",{"$f":"SUM(B6:B13)","v":253},{"$f":"SUM(C6:C13)","v":121561.3328},{"$f":"SUM(D6:D13)","v":930},163378.49000000002,116,203132.11,1299,488071.56280000007]
["Apr-20",19,11880,40,15200,11,27559.1,70,54638.720000000001]
["May-20",33,21706,48,14911.19,26,47956.3,107,84573.49]
["Jun-20",43,18704,136,28221,9,23289,188,70214]
["Jul-20",40,17454.84,191,20187.64,12,10319.200000000001,243,47961.68]
["2020-08-01",26,5592.7,163,21144.71,24,31681.8,{"$f":"SUM(B10,D10,F10)","v":213},{"$f":"SUM(C10,E10,G10)","v":58419.21}]
["2020-09-01",34,12161.71,145,28999.54,10,23227.4,189,64388.65]
["2020-10-01",26,16792.11,110,24320.69,11,21218.01,147,62330.82]
["2020-11-01",32,17269.9728,97,10393.719999999999,13,17881.3,142,45544.992799999993]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: BSE and NSE"]

{"sheet":"13","index":13,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Table 13: Trading in the Corporate Debt Market"]
["Year / Month","BSE",null,"NSE",null,"MSEI",null,"Total"]
[null,"No. of Trades","Traded Value (₹crore)","No. of Trades","Traded Value (₹crore)","No. of Trades","Traded Value (₹crore)","No. of Trades","Traded Value (₹crore)"]
["2019-20",57669,764268.62,80558,1463552.27,0,0,138227,2227820.96]
["2020-21$",{"$f":"SUM(B6:B13)","v":43047},{"$f":"SUM(C6:C13)","v":469624.65122430201},{"$f":"SUM(D6:D13)","v":46790},881046.50199999998,0,0,89837,1350671.153224302]
["Apr-20",3753,65285.07,5173,149229.69,0,0,{"$f":"B6+D6","v":8926},{"$f":"E6+C6","v":214514.76}]
["May-20",4677,64964.767999999996,6004,131841.63199999998,0,0,{"$f":"B7+D7","v":10681},{"$f":"E7+C7","v":196806.39999999997}]
["Jun-20",7231,76987.05,7647,130256.79,0,0,14878,207243.84]
["Jul-20",6813,80074.63,6710,121730.01,0,0,13523,201804.64]
["2020-08-01",4946,53915.519999999997,5200,89136.44,0,0,{"$f":"SUM(B10,D10,F10)","v":10146},{"$f":"SUM(C10,E10,G10)","v":143051.96}]
["2020-09-01",5695,50693.919999999998,5864,90782.64,0,0,11559,141476.56]
["2020-10-01",5019,42448.36,5332,88404.000000000015,0,0,10351,130852.36000000002]
["2020-11-01",4913,35255.333224302012,4860,79665.3,0,0,9773,114920.633224302]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: BSE, NSE & MSEI"]

{"sheet":"14","index":14,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,5],[16,0,16,5],[0,0,0,12],[1,0,2,0],[1,1,1,8],[1,9,2,10],[1,11,2,12],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["Table 14: Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["Grade","Investment Grade",null,null,null,null,null,null,null,"Non-Investment Grade",null,"Total"]
[null,"Highest Safety (AAA)",null,"High Safety (AA)",null,"Adequate Safety (A)",null,"Moderate Safety (BBB)"]
["Period","No. of issue","Amount  (₹crore)","No. of issue","Amount  (₹crore)","No. of issue","Amount  (₹ crore)","No. of issue","Amount  (₹crore)","No. of issue","Amount  (₹ crore)","No. of issue","Amount  (₹ crore)"]
["2019-20",315,1895046.59,308,194418.72,278,40357.379999999997,200,31405.884999999998,44,10059.959999999999,1145,2171738.5350000001]
["2020-21$",{"$f":"SUM(B7:B14)","v":179},{"$f":"SUM(C7:C14)","v":1379321.7900000003},317,255998.54000000004,196,34329.03,123,30892.739999999998,34,6140.7000000000007,849,1706682.7200000002]
["Apr-20",25,540951.9,28,52120.9,11,5075,5,1630.19,2,535,71,600312.99]
["May-20",17,76524.42,38,19249.330000000002,21,5426.38,7,620,1,100,84,101920.13]
["Jun-20",30,49056.53,43,33536.160000000003,36,4757.08,27,19665.78,0,0,136,107015.55]
["Jul-20",23,115681.76,41,16437.48,22,2665.11,22,866.59,7,352,115,136003.01999999999]
["Aug-20",18,148303.47,24,25639.17,32,6989.12,17,3401.9,3,167,94,184500.66]
["2020-09-01",34,357648.64000000001,63,58608.86,34,5034.5200000000004,17,2227.8200000000002,7,2544.0500000000002,155,426063.89]
["Oct-20",22,64275.07,35,21266.639999999999,10,1254.93,10,772.91,10,1687.65,87,89257.2]
["Nov-20",10,26880,45,29140,30,3126.89,18,1707.55,4,755,107,61609.279999999999]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: Credit Rating Agencies."]

{"sheet":"15","index":15,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,12],[15,0,15,12],[0,0,0,12],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
["Table 15: Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["Grade","Upgraded",null,"Downgraded",null,"Reaffirmed",null,"Rating Watch",null,"Withdrawn/ Suspended",null,"Total"]
["Period","No. of issue","Amount (₹crore)","No. of issue","Amount (₹crore)","No. of issue","Amount (₹crore)","No. of issue","Amount (₹crore)","No. of issue","Amount (₹crore)","No. of issue","Amount (₹crore)"]
["2019-20",252,75088.09,1689,1854100.55,4425,9132486.0999999996,768,739873.1,1193,580065.56999999995,8184,12225936.51]
["2020-21$",{"$f":"SUM(B6:B13)","v":156},{"$f":"SUM(C6:C13)","v":93911.239999999991},642,270805.55,4307,10069283.902000001,207,127823.18,1001,1003778.51,6164,11388745.867000001]
["Apr-20",4,598.4,78,18083.34,335,1772609.63,46,24584.43,181,514291.99,644,2330167.7949999999]
["May-20",4,37.630000000000003,85,57246.42,493,1201121.33,29,40188.47,82,42963.5,689,1340951.46]
["Jun-20",9,2751.45,78,47594.14,700,1263013.22,16,13712.15,104,55701.22,889,1361302.26]
["Jul-20",6,138.13,61,11188,567,1234071.6499999999,9,3821.4,111,76813.8,737,1310780.67]
["Aug-20",21,7118.39,67,24674.93,612,1496279.868,15,5088.58,115,117215.56,803,1589777.4480000001]
["2020-09-01",38,51115,127,57497.39,832,1777440.6680000001,27,18424.75,189,97682.6,1186,1966397.2379999999]
["Oct-20",29,1063.24,75,38775.129999999997,346,726268.64800000004,27,12466.2,142,78441.39,572,816353.21799999999]
["Nov-20",45,31089,71,15746.2,422,598478.88800000004,38,9537.2000000000007,77,20668.45,644,673015.77800000005]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: Credit Rating Agencies."]

{"sheet":"16","index":16,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,4],[6,0,6,3],[7,0,7,3]]}
["Table 16: Distribution of Turnover on Cash Segments of Stock Exchanges (₹crore)"]
["Stock Exchanges","Nov-20","2019-20","2020-21$"]
["BSE",70675.89,660896.02,591428.20000000007]
["MSEI",0.28305000000000002,27.988247170000001,4.84]
["NSE",1337271.92,8998811.0710000005,{"$f":"8210229.441+1337271.92","v":9547501.3609999996}]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"17","index":17,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,13,1,15],[14,0,14,7],[0,0,0,16],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[15,0,15,7],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12]]}
["Table 17: Trends in Cash Segment of BSE "]
["Year / Month","No. of Companies Listed ","No. of Companies Permitted*","No. of companies traded ","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (₹ crore)","Average Daily Turnover (₹ crore)","Average Trade Size (₹ )","Demat Securities Traded (Lakh)","Demat Turnover (₹crore)","Market  Capitalisation (₹ crore) ","S&P BSE Sensex "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2019-20",5377,36,4089,247,3247.6,573547.84,660896.02,2675.6923886640002,20350.290060351999,573547.84,660895.9,11348756.59,42273.87,25638.9,29468.49]
["2020-21$",{"$f":"B13","v":5442},{"$f":"C13","v":28},3837,{"$f":"SUM(E6:E13)","v":166},{"$f":"SUM(F6:F13)","v":3396.26},{"$f":"SUM(G6:G13)","v":597823.6},{"$f":"SUM(H6:H13)","v":591428.19999999995},{"$f":"H5/E5","v":3562.8204819277107},{"$f":"H5/F5*100","v":17414.102571652344},{"$f":"SUM(K6:K13)","v":597823.6},{"$f":"SUM(L6:L13)","v":591428.15999999992},{"$f":"M13","v":17414859.59},{"$f":"MAX(N6:N13)","v":44825.37},{"$f":"MIN(O6:O13)","v":27500.79},{"$f":"P13","v":44149.72}]
["Apr-20",5380,36,3352,18,349.14,38886.06,44476.34,2470.9077779999998,12738.82683,38886.06,44476.34,12941620.82,33887.25,27500.79,33717.620000000003]
["May-20",5369,36,3303,19,314.3,50830.89,65018.99,3422.0521052630002,20686.920139993999,50830.89,65018.97,12706528.939999999,32845.480000000003,29968.45,32424.1]
["Jun-20",5377,28,3481,22,555.78,108236.37,110192.7,5008.7590909090004,19826.676022887001,108236.37,110192.67,13915689.83,35706.550000000003,32348.1,34915.800000000003]
["Jul-20",5399,27,3624,23,513.70000000000005,98513.1,80092.740000000005,3482.2930434780001,15591.34514308,98513.1,80092.73,14739115.83,38617.03,34927.199999999997,37606.89,0]
["Aug-20",5413,27,3605,21,484.21,99670,93079.96,4432.3790476189997,19223.056112017999,99670,93079.99,15376302.710000001,40010.17,36911.230000000003,38628.29]
["2020-09-01",5428,28,3587,22,402.69,78826.509999999995,70025.27,3182.9668181820002,17389.373960117999,78826.509999999995,70025.27,15524267.369999999,39359.51,36495.980000000003,38067.93]
["Oct-20",5437,28,3543,21,364.27,54524.33,57866.31,2755.5385714290001,15885.554670985999,54524.33,57866.31,15792249.91,41048.050000000003,38410.199999999997,39614.07]
["Nov-20",5442,28,3551,20,412.17000000000013,68336.34,70675.89,3533.7945,17147.266904432632,68336.34,70675.87999999999,17414859.59,44825.37,39334.92,44149.72]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: BSE ."]
[]
[]
[null,null,null,null,{"$f":"SUM(E6:E13)","v":166},{"$f":"SUM(F6:F13)","v":3396.26},597823.6,591428.19999999995,28288.690954879999,{"$f":"SUM(J6:J13)","v":138489.01978351566},597823.6,591428.15999999992]
[null,null,null,null,{"$f":"E5-E19","v":0},{"$f":"F5-F19","v":0},0,0,{"$f":"I19/8","v":3536.0863693599999},{"$f":"J19/8","v":17311.127472939457},0,0]
[]
[null,null,null,null,null,null,null,null,{"$f":"H6/E6","v":2470.9077777777775},{"$f":"I22-I6","v":-2.2222229745239019E-7},{"$f":"H6/F6*100","v":12738.826831643466},{"$f":"K22-J6","v":1.6434660210506991E-6}]
[null,null,null,null,null,null,null,null,3422.052105263158,1.5779733075760305E-10,20686.920139993636,-3.637978807091713E-10]
[null,null,null,null,null,null,null,null,5008.7590909090904,9.0039975475519896E-11,19826.676022886757,-2.4374458007514477E-10]
[null,null,null,null,null,null,null,null,3482.2930434782611,2.610249794088304E-10,15591.345143079619,-3.80168785341084E-10]
[null,null,null,null,null,null,null,null,4432.3790476190479,4.8203219193965197E-11,19223.056112017515,-4.8385118134319782E-10]
[null,null,null,null,null,null,null,null,3182.9668181818183,-1.8189894035458565E-10,17389.373960118206,2.0736479200422764E-10]
[null,null,null,null,null,null,null,null,2755.5385714285712,-4.2882675188593566E-10,15885.554670985806,-1.9281287677586079E-10]
[null,null,null,null,null,null,null,null,3533.7945,0,17147.266904432632,0]

{"sheet":"18","index":18,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,13,1,15],[14,0,14,7],[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[15,0,15,7],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12]]}
["Table 18: Trends in Cash Segment of NSE "]
["Year / Month","No. of Companies Listed ","No. of Companies Permitted*","No. of companies traded ","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (₹ crore)","Average Daily Turnover (₹crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (` crore)","Market  Capitalisation (` crore) ","Nifty 50 Index "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2019-20",1949,18,1989,247,31459.712469999999,4674056.682,8998811.0710000005,36432.43348,28604.238130000002,4674056.682,8998811.0710000005,11243111.77,12430.5,7511.1,8597.75]
["2020-21$",1959,22,1983,166,29278.878809999998,4617739.5149999997,9547501.3560000006,57515.06841,32608.83526,4617739.5149999997,9547501.3560000006,17271314.449999999,13145.85,8055.8,12968.95]
["Apr-20",1949,18,1855,18,3606.19038,427307.91,905802.22,50322.345560000002,25117.98115,427307.91,905802.22,12738625.880000001,9889.0499999999993,8055.8,9859.9]
["May-20",1947,18,1854,19,3417.96702,493359.26549999998,1000456.48,52655.604209999998,29270.51297,493359.26549999998,1000456.48,12516959.59,9598.85,8806.75,9580.2999999999993]
["Jun-20",1944,18,1872,22,4304.0271700000003,845760.36840000004,1350680.7239999999,61394.57836,31381.788970000001,845760.36840000004,1350680.7239999999,13804601.48,10553.15,9544.35,10302.1]
["Jul-20",1941,18,1886,23,3950.4627099999998,667758.13970000006,1348520.9850000001,58631.347159999998,34135.77304,667758.13970000006,1348520.9850000001,14629658.609999999,11341.4,10299.6,11073.45]
["Aug-20",1943,18,1886,21,3783.65128,659450.22499999998,1282556.5349999999,61074.120699999999,33897.324030000003,659450.22499999998,1282556.5349999999,15234206.699999999,11794.25,10882.25,11387.5]
["Sep-20",1946,18,1892,22,3596.4906099999998,574785.84840000002,1223328.7339999999,55605.851519999997,34014.5121,574785.84840000002,1223328.7339999999,15304722.35,11618.1,10790.2,11247.55]
["Oct-20",1959,22,1908,21,3181.93019,418797.67969999998,1098883.7649999999,52327.798309999998,34535.131159999997,418797.67969999998,1098883.7649999999,15587902.939999999,12025.45,11347.05,11642.4]
["Nov-20",1959,22,1899,20,3438.1594500000001,530520.07845000003,1337271.9151294169,66863.600000000006,38894.994100000004,530520.07845000003,1337271.9151294169,17271314.4541067,13145.85,11557.4,12968.95]
["Notes -"]
["Turnover Data compiled for all markets except auction market"]
["$ indicates as on November 30, 2020"]
["* As on November 30, 2020"]
["Source: NSE"]

{"sheet":"19","index":19,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,11,2,11],[1,12,2,12],[1,13,1,15],[15,0,15,15],[17,0,17,15],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,4,2,4]]}
["Table 19: Trends in Cash Segment of MSEI"]
["Year/Month","No. of Companies Listed ","No. of Companies Permitted **","No. of Companies Traded","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (₹ crore)","Average Daily Turnover (₹ crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (₹ crore)","Market  Capitalisation (₹ crore) *","SX 50 Index "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2019-20",295,1256,15,247,7.4999999999999997E-3,12.98218,27.988247170000001,0.11331274199999999,373176.62893333298,15.349758233999999,20.30463782,11034810.51,24440.1,15102.84,17120.96]
["2020-21$",298,1254,5,{"$f":"SUM(E6:E13)","v":166},{"$f":"SUM(F6:F13)","v":2.5700000000000002E-3},{"$f":"SUM(G6:G13)","v":1.3566799999999999},{"$f":"SUM(H6:H13)","v":4.8355222500000004},{"$f":"H5/E5","v":2.9129652108433737E-2},{"$f":"H5/(F5/100)","v":188152.61673151751},0,0,16730075.904938348,25893.97,16065.53,25707.37]
["Apr-20",296,1257,3,18,1.2999999999999999E-4,0.19211,0.692056,3.8447556000000001E-2,532350.76923076902,0,0,12577219.92,19582.8,16065.53,19582.82]
["May-20",295,1257,0,19,0,0,0,0,0,0,0,12348176.5,18975.599999999999,17527.78,18975.599999999999]
["Jun-20",295,1256,3,22,1.8000000000000001E-4,0.19714000000000001,0.70960880000000004,3.2254945E-2,394227.11109999998,0,0,13487770.939999999,20692.27,19439.25,20394.990000000002]
["Jul-20",296,1257,1,23,6.9999999999999994E-5,5.91E-2,0.21276,9.2504349999999996E-3,303942.85710000002,0,0,14394821.939999999,22504.43,20643.12,22015.439999999999]
["Aug-20",297,1258,2,21,2.9E-4,0.32501000000000002,1.153661,5.4936237999999998E-2,397814.13793103403,0,0,14933471.630000001,23093.360000000001,21661.75,22609.56]
["2020-09-01",297,1260,4,22,1.1100000000000001E-3,0.32167000000000001,1.1437114500000001,5.1986883999999997E-2,103037.067567568,0,0,14948126.76,23068.57,21505,22386.29]
["Oct-20",297,1255,1,21,5.9999999999999995E-4,0.18304999999999999,0.64067499999999999,3.0508332999999999E-2,106779.16666666701,0,0,15176584.51,23871.67,22720.35,23186.74]
["Nov-20",298,1254,2,20,1.9000000000000001E-4,7.8600000000000003E-2,0.28305000000000002,{"$f":"H13/E13","v":1.4152500000000002E-2},{"$f":"H13/(F13/100)","v":148973.68421052632},0,0,16730075.904938348,25893.97,23186.74,25707.37]
["Notes -"]
["* The data of the Market Capitalization provided in the Bulletin includes listed as well as permitted to trade companies"]
["$ indicates as on November 30, 2020"]
["**As on November 30, 2020"]
["Source: MSEI"]

{"sheet":"20","index":20,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,0,27,7],[28,0,28,7],[29,0,29,7],[0,0,0,7],[1,0,1,7],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7]]}
["Table 20: City-wise Distribution of Turnover on Cash Segments "]
["(Percentage share in Turnover)"]
["S.No","City","BSE",null,"NSE",null,"MSEI"]
[null,null,"2019-20","2020-11-01","2019-20","2020-11-01","2019-20","2020-11-01"]
[1,"Ahmedabad",2.2055113240000002,12.606444920885506,1.65,4.8099999999999996,1.04,0]
[2,"Bengaluru",1.1804078,0.53642684769228932,3.22,1.72,0,0]
[3,"Vadodra",0.73076405899999997,0.4661740770345893,0.24,0.15,0,0]
[4,"Bhubneshwar",1.6662054999999999E-2,1.6364277484107057E-2,0,0,0,0]
[5,"Chennai",0.73378679199999997,0.28346982582216618,0.87,0.59,0,0]
[6,"Cochin/Ernakulum",8.0620224000000004E-2,5.3069744271508824E-2,0.7,0.63,0,0]
[7,"Coimbatore",2.5038392E-2,1.3958566286419845E-2,0.05,0.05,0,0]
[8,"New Delhi",1.080805639,1.3734595132827283,5.92,4.67,48.72,50]
[9,"Guwahati",2.7876812000000001E-2,3.7131451830790252E-2,0,0,0,0]
[10,"Hyderabad",0.28056737300000001,0.10775453540862456,3.13,3.53,0,0]
[11,"Indore",0.246330406,0.26549578267393542,0.3,0.3,0,0]
[12,"Jaipur",0.49095509999999998,0.30861687250614778,0.3,0.2,0,8.81]
[13,"Kanpur",0.25279658399999999,0.19548096297278475,0.08,0.1,1.93,0]
[14,"Kolkata",3.4114442089999999,3.9361194001137059,5.24,3.64,0,0]
[15,"Ludhiana",7.3506302999999995E-2,7.7316922146292461E-2,0.11,0.06,0,0]
[16,"Mangalore",1.3216734000000001E-2,8.0013787563368785E-3,0,0,0,0]
[17,"Mumbai",51.073666179999996,34.072636597913089,64.040000000000006,70.27,21.1,0]
[18,"Patna",3.3395598999999998E-2,1.8717271088131791E-2,0,0,0,0]
[19,"Pune",0.26363530600000001,0.45278982581788191,0.08,0.12,0,0]
[20,"Rajkot",1.609832749,1.908020229485393,1.07,0.86,0,0]
[21,"Others",36.169180359999999,43.262550996527573,13,8.3000000000000007,27.21,41.19]
[null,"Total",100,100,100,100,100,100]
["Notes -"]
["The city-wise distribution of turnover is based on the cities uploaded in the UCC database of the Exchange for clientele trades and members registered office city for proprietary trades."]
[]
["Source: BSE, NSE and MSEI."]

{"sheet":"21","index":21,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,2,0],[1,1,1,5],[14,0,14,4],[15,0,15,4]]}
["Table 21: Category-wise Share of Turnover in Cash Segment of BSE"]
["Year / Month","Percentage Share in Turnover"]
[null,"Proprietary","FPIs","Mutual Funds","Banks","Others"]
["2019-20",27.638330646670354,9.9766449832928519,7.3355729394431721,0.11697282202055018,54.932478608573021]
["2020-21$",31.914018906971666,13.052648100999129,2.7734215402406894,9.030868622677822E-2,52.169602765561663]
["Apr-20",38.65,9.98,2.74,0.01,48.61]
["May-20",28.1,22,5.33,0.02,44.54]
["Jun-20",27.04,24,2.89,0.01,46.06]
["Jul-20",36.619999999999997,3.13,2.2599999999999998,0.01,57.98]
["Aug-20",30.41,8.9700000000000006,1.91,0.1,58.61]
["Sept-20",33.79,7.81,2.99,0.05,55.36]
["Oct-20",33.32,10.69,2.5099999999999998,0.14000000000000001,53.34]
["Nov-20",32.47,10.6,1.97,0.41,54.55]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: BSE."]

{"sheet":"22","index":22,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,2,0],[1,1,1,5],[14,0,14,5],[15,0,15,5]]}
["Table 22: Category-wise Share of Turnover in Cash Segment of NSE"]
["Year /Month","Percentage Share in Turnover"]
[null,"Proprietary","FPIs","Mutual Funds","Banks","Others"]
["2019-20",22.74,15.18,7.47,0.17,54.45]
["2020-21$",23.88,11.31,5.04,0.09,59.68]
["Apr-20",22.68,13.45,6.19,0.06,57.62]
["May-20",21.62,13.44,6.17,0.05,58.72]
["Jun-20",23.22,9.32,5,0.17,62.29]
["Jul-20",21.67,8.16,4.6900000000000004,0.08,65.400000000000006]
["Aug-20",23.12,9.0500000000000007,4.3099999999999996,0.12,63.39]
["2020-09-01",26.6,10.38,4.84,0.09,58.1]
["Oct-20",26.32,11.29,4.92,7.0000000000000007E-2,57.4]
["2020-11-01",25.55,16.489999999999998,4.7699999999999996,0.06,53.14]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: NSE."]

{"sheet":"23","index":23,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[14,0,14,5],[15,0,15,5]]}
["Table 23: Category-wise Share of Turnover in Cash Segment of MSEI"]
["Year / Month","Percentage Share in Turnover"]
[null,"Proprietary","FPIs","Mutual Funds","Banks","Others"]
["2019-20",0,0,0,0,100]
["2020-21$",0,0,0,0,100]
["Apr-20",0,0,0,0,100]
["May-20",0,0,0,0,0]
["Jun-20",0,0,0,0,100]
["Jul-20",0,0,0,0,100]
["Aug-20",0,0,0,0,100]
["2020-09-01",0,0,0,0,100]
["Oct-20",0,0,0,0,100]
["2020-11-01",0,0,0,0,100]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: MSEI."]

{"sheet":"24","index":24,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,9],[0,0,0,10],[32,0,32,9],[33,0,33,9],[34,0,34,9],[35,0,35,9]]}
["Table 24: Component Stocks: S&P BSE Sensex during Nov-20"]
["Sl.No","Name of Security","Issued Capital \n(₹ crore)","Free Float\nMarket\nCapitalisation\n( ₹ crore)","Weightage (per cent)","Beta","R2","Daily\nVolatility\n(per cent)","Monthly\nReturn\n(per cent)","Impact\nCost\n(per cent)"]
[1,"Reliance Industries Limited",6339.44,623315.14000300004,12.953967142,1.08,0.55420100000000005,2.96,-6.0603109999999996,0.02]
[2,"HDFC Bank Limited",550.66,586282.59568999999,12.184343028000001,1.08,0.72126199999999996,2.59,21.737293000000001,0.02]
[3,"Infosys Limited",2129.75,406514.12868700002,8.4483278649999995,0.85,0.47950399999999999,2.5,3.7667350000000002,0.02]
[4,"Housing Development Finance Corporation Limited",359.68,404422.69936500001,8.4048630030000009,1.22,0.67523699999999998,3.04,17.412559999999999,0.03]
[5,"ICICI Bank Limited",1379.97,326015.03207999998,6.7753656900000001,1.42,0.725769,3.4,20.443255000000001,0.03]
[6,"Tata Consultancy Services Limited",375.24,281489.66363700002,5.8500229170000004,0.72,0.41756100000000002,2.2599999999999998,0.53661499999999995,0.02]
[7,"Kotak Mahindra Bank Limited",989.89,248357.51335600001,5.1614582430000002,1.08,0.57757700000000001,2.91,22.877358000000001,0.03]
[8,"Hindustan Unilever Limited",234.96,190792.917713,3.9651293999999999,0.59,0.32299800000000001,2.11,3.1317849999999998,0.03]
[9,"ITC Limited",1230.5,169223.26027100001,3.5168607540000001,0.65,0.29456399999999999,2.44,17.216338,0.03]
[10,"Axis Bank Limited",612.09,158452.05351999999,3.2930095279999998,1.59,0.63189499999999998,4.08,22.278635000000001,0.03]
[11,"Larsen & Toubro Limited",280.85000000000002,134394.71350499999,2.7930409369999998,0.95,0.55412899999999998,2.59,20.03012,0.03]
[12,"Bajaj Finance Limited",120.52,129811.513643,2.6977911730000002,1.51,0.58660699999999999,4.01,48.241197999999997,0.03]
[13,"Bharti Airtel Limited",2727.78,111212.62055599999,2.311262057,0.76,0.316162,2.76,6.8496300000000003,7.0000000000000007E-2]
[14,"Asian Paints Limited",95.92,99963.251208999995,2.0774734779999999,0.69,0.40090199999999998,2.21,0.194301,0.04]
[15,"State Bank of India",892.46,93751.904481000005,1.948386959,1.1399999999999999,0.58827200000000002,3.03,29.088507,0.03]
[16,"Maruti Suzuki India Limited",151.04,93395.523583999995,1.940980519,1.0900000000000001,0.566164,2.96,1.0134840000000001,0.03]
[17,"HCL Technologies Limited",542.73,89210.607504,1.854008036,0.76,9.2989000000000002E-2,5.0599999999999996,-2.4905119999999998,0.06]
[18,"Mahindra & Mahindra Limited",621.6,68871.463367999997,1.4313123750000001,0.97,0.40804800000000002,3.09,21.251156999999999,0.04]
[19,"Nestle India Ltd",96.42,62991.580978999998,1.3091144720000001,0.55000000000000004,0.286273,2.09,2.8829790000000002,0.05]
[20,"Titan Company Limited",88.78,56657.570345,1.177478706,0.87,0.473806,2.58,16.563652999999999,0.04]
[21,"UltraTech Cement Limited",288.63,55445.635540000003,1.1522918259999999,0.9,0.55908599999999997,2.44,5.0045359999999999,0.05]
[22,"Sun Pharmaceuticals Industries Limited",239.93,55230.043108999998,1.147811304,0.6,0.26193499999999997,2.38,9.8336009999999998,0.04]
[23,"Tech Mahindra Limited",483.51,54037.511509999997,1.1230276690000001,0.83,0.40655200000000002,2.64,7.6748180000000001,0.04]
[24,"Bajaj Finserv Limited",79.569999999999993,52942.501786000001,1.100270769,1.38,0.61123499999999997,3.59,57.089030000000001,0.04]
[25,"IndusInd Bank Limited",756.47,51702.979983999998,1.0745105660000001,1.69,0.40140300000000001,5.45,46.456625000000003,0.08]
[26,"Power Grid Corporation of India Limited",5231.59,49346.972674999997,1.0255471460000001,0.57999999999999996,0.29495100000000002,2.1800000000000002,12.573098999999999,0.05]
[27,"NTPC Limited",9894.56,45671.300816000003,0.94915796500000005,0.66,0.32588299999999998,2.35,7.5342460000000004,0.05]
[28,"Tata Steel Limited",1145.9000000000001,42315.715691999998,0.87942094699999995,1.05,0.477908,3.1,40.818812999999999,0.03]
[29,"Bajaj Auto Limited",289.37,41312.852334000003,0.85857906799999995,0.79,0.46702900000000003,2.37,9.9152930000000001,0.05]
[30,"Oil & Natural Gas Corporation Limited",6290.14,28639.005143999999,0.59518645999999997,1,0.37431599999999998,3.33,20.862200999999999,7.0000000000000007E-2]
["Notes: 1. Beta & R2 are calculated for the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2. The above is calculated for a month for the portfolio size of ` 5 lakh.  It is calculated for the current month."]
["Source: BSE."]

{"sheet":"25","index":25,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,0,57,9],[0,0,0,10],[52,0,52,9],[53,0,53,9],[54,0,54,9],[55,0,55,9],[56,0,56,9]]}
["Table 25: Component Stocks: Nifty 50 Index during Nov-20"]
["Sl. No","Name of Security","Issued\nCapital \n(₹   crore)","Free Float Market\nCapitalisation\n(₹  crore)","Weightage (per cent)","Beta","R2","Daily\nVolatility\n(per cent)","Monthly\nReturn\n(per cent)","Impact\nCost\n(per cent)"]
[1,"HDFC Bank Ltd.",550.30999999999995,626405.27,11.21,1.0900000000000001,0.69,1.85,21.74,0.02]
[2,"Reliance Industries Ltd.",6339.41,623923.54,11.17,1.1100000000000001,0.54,2.77,-6.07,0.02]
[3,"Housing Development Finance Corporation Ltd.",358.26,404163.25,7.23,1.25,0.66,2.41,17.3,0.02]
[4,"Infosys Ltd.",2129.6999999999998,402938.79,7.21,0.87,0.46,1.77,3.71,0.02]
[5,"ICICI Bank Ltd.",1379.2,326421.95,5.84,1.44,0.71,2.7,20.57,0.03]
[6,"Tata Consultancy Services Ltd.",375.24,281542.17,5.04,0.73,0.4,1.28,0.56000000000000005,0.02]
[7,"Kotak Mahindra Bank Ltd.",989.6,279316.49,5,1.1000000000000001,0.56000000000000005,1.68,23.25,0.02]
[8,"Hindustan Unilever Ltd.",234.96,190905.21,3.42,0.62,0.33,1.1200000000000001,3.23,0.02]
[9,"ITC Ltd.",1230.47,169179.58,3.03,0.66,0.28000000000000003,1.57,17.190000000000001,0.03]
[10,"Axis Bank Ltd.",612.02,149116.74,2.67,1.59,0.62,2.7,22.15,0.03]
[11,"Larsen & Toubro Ltd.",280.81,137102.32,2.4500000000000002,0.96,0.54,2.2400000000000002,20.75,0.03]
[12,"Bajaj Finance Ltd.",120.52,130151.15,2.33,1.49,0.56000000000000005,2.42,48.35,0.02]
[13,"Bharti Airtel Ltd.",2727.78,111200.63,1.99,0.76,0.3,2.13,6.8,0.03]
[14,"Asian Paints Ltd.",95.92,99870.81,1.79,0.7,0.39,1.36,0.17,0.01]
[15,"State Bank of India",892.46,93732.96,1.68,1.17,0.57999999999999996,2.77,29.06,0.03]
[16,"Maruti Suzuki India Ltd.",151.04,93516.49,1.67,1.1299999999999999,0.56999999999999995,1.27,1.01,0.02]
[17,"HCL Technologies Ltd.",542.73,89236.160000000003,1.6,0.77,0.37,1.99,-2.36,0.03]
[18,"Mahindra & Mahindra Ltd.",621.6,69114.05,1.24,1.02,0.42,2.5099999999999998,21.55,0.02]
[19,"Nestle India Ltd.",96.42,63816.71,1.1399999999999999,0.59,0.3,1.49,4.24,0.03]
[20,"Dr. Reddy's Laboratories Ltd.",83.13,58607.11,1.05,0.47,0.17,1.83,-1.22,0.02]
[21,"Titan Company Ltd.",88.78,56797.36,1.02,0.89,0.46,1.86,16.77,0.03]
[22,"UltraTech Cement Ltd.",288.63,55439.3,0.99,0.93,0.56999999999999995,1.27,4.9800000000000004,0.02]
[23,"Sun Pharmaceutical Industries Ltd.",239.93,55242.89,0.99,0.63,0.27,1.86,9.86,0.03]
[24,"Tech Mahindra Ltd.",483.2,54232.98,0.97,0.86,0.42,2.0299999999999998,7.81,0.03]
[25,"Bajaj Finserv Ltd.",79.569999999999993,52966.36,0.95,1.36,0.6,2.57,57.15,0.03]
[26,"Wipro Ltd.",1142.9000000000001,52076.15,0.93,0.67,0.28000000000000003,1.37,2.88,0.02]
[27,"HDFC Life Insurance Company Ltd.",2019.34,50938.17,0.91,1.07,0.53,1.83,9.67,0.02]
[28,"Power Grid Corporation of India Ltd.",5231.59,49321.33,0.88,0.6,0.28999999999999998,1.55,12.51,0.03]
[29,"IndusInd Bank Ltd.",756.31,48648.91,0.87,1.67,0.35,3.39,46.43,0.1]
[30,"Divi's Laboratories Ltd.",53.09,45937.96,0.82,0.55000000000000004,0.22,2.2200000000000002,14.74,0.03]
[31,"NTPC Ltd.",9894.56,45913.71,0.82,0.67,0.32,1.69,8.11,0.03]
[32,"Tata Steel Ltd.",1126.49,43575.37,0.78,1.1200000000000001,0.5,2.46,40.630000000000003,0.02]
[33,"Britannia Industries Ltd.",24.07,42911.64,0.77,0.75,0.41,0.93,4.74,0.02]
[34,"Bajaj Auto Ltd.",289.37,41324.43,0.74,0.81,0.45,0.99,9.93,0.03]
[35,"Hero MotoCorp Ltd.",39.950000000000003,40364.43,0.72,0.88,0.39,1.64,11.04,0.02]
[36,"Cipla Ltd.",161.27000000000001,37875.74,0.68,0.45,0.13,2.0099999999999998,-1.18,0.03]
[37,"Eicher Motors Ltd.",27.32,35318.39,0.63,0.87,0.38,2.48,21.53,0.03]
[38,"JSW Steel Ltd.",241.72,34706.93,0.62,1.3,0.63,2,13.33,0.03]
[39,"Grasim Industries Ltd.",131.59,34570.839999999997,0.62,1.1399999999999999,0.56000000000000005,1.51,12.51,0.02]
[40,"Hindalco Industries Ltd.",224.63,33049.019999999997,0.59,1.41,0.59,2.54,32.64,0.03]
[41,"SBI Life Insurance Company Ltd.",1000.05,32997.480000000003,0.59,0.91,0.49,1.29,10,0.03]
[42,"Shree Cement Ltd.",36.08,32448.68,0.57999999999999996,0.85,0.49,1.43,12.04,0.03]
[43,"Tata Motors Ltd.",617.79,32311.59,0.57999999999999996,1.28,0.42,2.8,35.96,0.03]
[44,"Adani Ports and Special Economic Zone Ltd.",406.35,30102.03,0.54,0.91,0.44,1.85,14.37,0.03]
[45,"Bharat Petroleum Corporation Ltd.",2169.25,29937.86,0.54,1.07,0.41,2.5,5.23,0.03]
[46,"Oil & Natural Gas Corporation Ltd.",6290.14,28639.01,0.51,1.01,0.34,2.2400000000000002,20.96,0.04]
[47,"Coal India Ltd.",6162.73,26306.84,0.47,0.66,0.26,1.95,9.94,0.04]
[48,"UPL Ltd.",152.81,22978.21,0.41,1.08,0.43,2.1800000000000002,-7.84,0.03]
[49,"Indian Oil Corporation Ltd.",9414.16,21503.82,0.38,0.72,0.41,1.39,6.35,0.04]
[50,"GAIL (India) Ltd.",4510.1400000000003,18981.61,0.34,0.79,0.28000000000000003,1.91,21.12,0.04]
["Notes: 1. Beta & R2 are calculated for the the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2."]
["5. Impact Cost for Nifty 50 is for a portfolio of Rs. 50 lakhs  and is weightage average impact cost."]
["Source: NSE."]

{"sheet":"26","index":26,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,0,47,9],[0,0,0,1],[42,0,42,9],[43,0,43,9],[44,0,44,9],[45,0,45,9],[46,0,46,9]]}
["Table 26: Component Stocks: SX40 Index"]
["S.No.","Name of Security","Issued Capital     (₹ crore)","Free Float Market Capitalisation (₹ crore)","Weightage (per cent)   ","Beta","R2","Daily Volatility (per cent)","Monthly Return (per cent)","Impact Cost (per cent) *"]
[1,"HDFC Bank Limited",550.41321909999999,625257.7734483449,11.989832570000001,1.0900000000000001,0.69,"NA","NA","Na"]
[2,"Reliance Industries Limited",6339.4407199999996,582084.75171222002,11.161954339999999,1.1299999999999999,0.55000000000000004,"NA","NA","Na"]
[3,"Infosys Limited",2183.2281555,417755.9474,8.0108142300000011,0.88,0.48,"NA","NA","Na"]
[4,"Housing Development Finance Corporation Limited",348.29875060000001,392924.528020625,7.5346513200000009,1.25,0.66,"NA","NA","Na"]
[5,"ICICI Bank Limited",1379.9170598000001,326584.10662014503,6.2625191200000003,1.44,0.71,"NA","NA","Na"]
[6,"Tata Consultancy Services Limited",375.23847060000003,281053.13571329002,5.3894252700000003,0.74,0.41,"NA","NA","Na"]
[7,"Kotak Mahindra Bank Limited",989.89255600000001,272966.62679208,5.2343598,1.1000000000000001,0.55000000000000004,"NA","NA","Na"]
[8,"Hindustan Unilever Limited",234.9556255,191399.56114653999,3.6702441600000002,0.63,0.33,"NA","NA","Na"]
[9,"ITC Limited",1230.3013042,168154.01954358001,3.2244917599999998,0.66,0.28000000000000003,"NA","NA","Na"]
[10,"Axis Bank Limited",611.9933168,157445.05923968001,3.01913863,1.58,0.61,"NA","NA","Na"]
[11,"Larsen & Toubro Limited",280.79857440000001,135971.43229936002,2.6073641599999999,0.95,0.53,"NA","NA","Na"]
[12,"Bajaj Finance Limited",120.5099678,128839.4671616,2.4706028600000001,1.47,0.55000000000000004,"NA","NA","Na"]
[13,"Bharti Airtel Limited",2727.7786775,110552.142775275,2.1199283499999999,0.76,0.3,"NA","NA","Na"]
[14,"Asian Paints Limited",95.919779000000005,100311.69401808,1.9235593200000001,0.7,0.39,"NA","NA","Na"]
[15,"State Bank of India",892.46115339999994,93482.331911874993,1.7926006800000001,1.17,0.57999999999999996,"NA","NA","Na"]
[16,"Maruti Suzuki India Limited",151.04003,92729.239346839997,1.7781595099999998,1.1299999999999999,0.56999999999999995,"NA","NA","Na"]
[17,"HCL Technologies Limited",542.73301919999994,88496.995116620004,1.6970027400000001,0.78,0.38,"NA","NA","Na"]
[18,"Mahindra & Mahindra Limited",621.596272,69146.553555599996,1.3259420900000001,1.02,0.41,"NA","NA","Na"]
[19,"Nestle India Ltd",96.415716000000003,64222.470026114999,1.2315187400000001,0.59,0.3,"NA","NA","Na"]
[20,"Dr. Reddy's Laboratories Limited",85.676520499999995,61091.750993804992,1.17148462,0.47,0.17,"NA","NA","Na"]
[21,"Titan Company Limited",88.778616,56923.238748800002,1.09154997,0.88,0.45,"NA","NA","Na"]
[22,"Tech Mahindra Limited",493.80288949999999,56233.646324570007,1.07832646,0.87,0.42,"NA","NA","Na"]
[23,"Sun Pharmaceuticals Industries Limited",239.92753300000001,55623.558776174999,1.0666275299999999,0.63,0.27,"NA","NA","Na"]
[24,"UltraTech Cement Limited",288.63136600000001,55469.285936400003,1.0636692299999999,0.93,0.56000000000000005,"NA","NA","Na"]
[25,"HDFC Life Insurance Company Limited",2019.9306509999999,51715.893241319995,0.99169483000000003,0.69,0.1,"NA","NA","Na"]
[26,"Wipro Limited",1143.0676178000001,51295.296495050003,0.98362954000000002,0.68,0.28999999999999998,"NA","NA","Na"]
[27,"Power Grid Corporation of India Limited",5231.5896480000001,48979.599697600002,0.93922415000000004,0.59,0.28999999999999998,"NA","NA","Na"]
[28,"IndusInd Bank Limited",756.47299299999997,48653.545544779998,0.93297178999999997,1.66,0.34,"NA","NA","Na"]
[29,"NTPC Limited",9894.5572800000009,45895.974040840003,0.88009309000000002,0.66,0.31,"NA","NA","Na"]
[30,"Britannia Industries Limited",24.086829600000002,43333.58839818,0.83095722999999999,0.74,0.4,"NA","NA","Na"]
[31,"Tata Steel Limited",1126.4923739999999,41115.040150995002,0.78841473999999989,1.1100000000000001,0.49,"NA","NA","Na"]
[32,"Hero MotoCorp Limited",39.953522,40516.252083164996,0.77693248999999998,0.87,0.38,"NA","NA","Na"]
[33,"Bajaj Auto Limited",289.36702000000002,38283.752293199999,0.73412246999999997,0.8,0.45,"NA","NA","Na"]
[34,"Cipla Limited",161.28922019999999,38097.215252800001,0.73054547000000003,0.01,0,"NA","NA","Na"]
[35,"Grasim Industries Limited",131.5878458,33925.602184000003,0.65055134999999997,1.1299999999999999,0.55000000000000004,"NA","NA","Na"]
[36,"Hindalco Industries Limited",224.64783869999999,33098.10158943,0.63468334999999998,1.4,0.57999999999999996,"NA","NA","Na"]
[37,"Adani Ports And Special Economic Zone Limited",406.35035219999997,30390.734553165003,0.58276736000000007,0.91,0.43,"NA","NA","Na"]
[38,"Bharat Petroleum Corporation Limited",2169.2140439999998,29802.377877200001,0.57148513000000001,1.06,0.41,"NA","NA","Na"]
[39,"Oil & Natural Gas Corporation Limited",6290.1396029999996,28930.264431399999,0.55476164000000006,1.01,0.34,"NA","NA","Na"]
[40,"Coal India Limited",6162.7283269999998,26147.39983821,0.50139792000000005,0.65,0.25,"NA","NA","Na"]
["Notes:"]
["1. Market Cap, Beta & R2 as on the last day of the month"]
["2. Beta & R2 are calculated for the trailing 12 months"]
["3. Volatility for the current month"]
["4. *Since there is no trading in the SX40 constituents, the Impact Cost for the given stocks is NiL."]
["Source: MSEI."]

{"sheet":"27","index":27,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,7,1,9],[13,0,13,5],[14,0,14,5],[15,0,15,5],[0,0,0,6],[1,0,2,0],[1,1,1,3],[1,4,1,6]]}
["Table 27: Advances/Declines in Cash Segment "]
["Year/ Month","BSE",null,null,"NSE",null,null,"MSEI"]
[null,"Advances","Declines","Advance/Decline Ratio","Advances","Declines","Advance/Decline Ratio","Advances","Declines","Advance/Decline Ratio"]
["2019-20",793,3134,0.25303126999999997,440,1530,0.28999999999999998,6,3,2]
["2020-21$",1229,2531,0.48557882259976293,626,1328,0.47,0,2,0]
["Apr-20",1291,1932,0.66821946200000004,825,1094,0.75,0,0,0]
["May-20",1410,1780,0.79213483100000004,914,977,0.94,0,0,0]
["Jun-20",2699,585,4.6136752139999997,1753,147,11.93,0,0,0]
["Jul-20",2243,1240,1.8088709679999999,1387,530,2.62,0,0,0]
["Aug-20",2322,1232,1.8847402600000001,1457,496,2.94,0,0,0]
["2020-09-01",1727,1821,0.94838001100000002,899,1056,0.85,0,0,0]
["Oct-20",1419,2095,0.677326969,777,1189,0.65,0,0,0]
["2020-11-01",2055,1437,{"$f":"B13/C13","v":1.4300626304801669},1294,674,1.92,0,0,0]
["Notes:  Advance/Decline is calculated based on the average price methodology.                                                                           "]
["$ indicates as on November 30, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"28","index":28,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,7,1,9],[14,0,14,6],[15,0,15,6],[0,0,0,6],[1,0,2,0],[1,1,1,3],[1,4,1,6]]}
["Table 28: Trading Frequency in Cash Segment of Exchanges"]
["Month","BSE",null,null,"NSE",null,null,"MSEI"]
[null,"No. of Companies Listed","No. of Companies Traded","Traded to Listed (per cent)","No. of Companies Listed","No. of Companies Traded","Traded to Listed (per cent)","No. of Companies Listed","No. of Companies Traded","Traded to Listed (per cent)"]
["2019-20",5377,4089,76.046122373070489,1949,1989,102.05233453052847,295,15,5.0847457627118651]
["2020-21$",5442,3857,70.874678427048877,1959,1974,100.7656967840735,298,5,1.6778523489932886]
["Apr-20",5380,3352,62.304832713754642,1949,1855,95.177013853258089,296,3,1.0135135135135136]
["May-20",5369,3303,61.519836096107284,1947,1854,95.223420647149453,295,0,0]
["Jun-20",5377,3481,64.738701878370847,1944,1872,96.296296296296291,295,3,1.0169491525423728]
["Jul-20",5399,3624,67.123541396554899,1941,1886,97.166409067490989,296,1,0.33783783783783783]
["Aug-20",5413,3605,66.598928505449834,1943,1886,97.066392177045799,297,2,0.67340067340067333]
["2020-09-01",5428,3587,66.083271923360357,1946,1892,97.225077081192197,297,4,1.3468013468013467]
["Oct-20",5437,3543,65.16461283796211,1959,1908,97.396630934150068,297,1,0.33670033670033667]
["2020-11-01",5442,3551,65.251745681734647,1959,1899,{"$f":"(F13/E13)*100","v":96.937212863705966},298,2,0.67114093959731547]
["Notes -"]
["$ indicates as on November 30, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"29","index":29,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,6],[14,0,14,6],[15,0,15,6]]}
["Table 29: Daily Volatility of Major Indices"]
[null,null,null,null,null,null,null,"(per cent)"]
["Year / Month","BSE Sensex","BSE 100","BSE 500","Nifty 50","Nifty Next 50","Nifty 500","SX40"]
["2019-20",1.77,1.74,1.7,1.7456697859999999,1.6196834090000001,1.6847958089999999,1.71]
["2020-21$",1.5396433181219211,1.4486851179212559,1.372083302198432,1.4942027069999999,1.2265050099999999,1.364200313,1.5]
["Apr-20",3.03,2.81,2.6,2.8437730370000001,1.971064465,2.5081819959999998,3.01]
["May-20",2.15,2.04,1.91,2.048551588,1.6476503140000001,1.852370831,2.0499999999999998]
["Jun-20",1.25,1.18,1.1499999999999999,1.2171892010000001,0.945600102,1.1310003790000001,1.21]
["Jul-20",0.97,0.88,0.82,0.92596389499999998,0.67255359400000003,0.80530851699999995,0.93]
["Aug-20",0.99,0.94,0.93,0.92569446200000005,1.101700468,0.91958686099999998,0.93]
["2020-09-01",1.1963697230000001,1.2295098019999999,1.2543283540000001,1.1696402370000001,1.353955553,1.2230164509999999,1.19]
["Oct-20",1.0282128479999999,0.93340800000000002,0.85826741699999998,0.94172470799999997,0.73736095300000004,0.835326122,0.98]
["2020-11-01",0.9033380901004372,0.82678346140161108,0.74836968301322426,0.83995939799999997,0.73352753999999998,0.72887254599999995,0.87]
["Notes: Volatility is calculated as the standard deviation of the natural log of daily returns in indices for the respective period."]
["$ indicates as on  November 30, 2020"]
["Source: BSE, MSEI and NSE."]

{"sheet":"30","index":30,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,10],[0,0,0,10],[1,1,1,5],[1,6,1,10],[1,11,1,15],[3,0,3,15],[14,0,14,15],[25,0,25,10],[26,0,26,10]]}
["Table 30: Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment of Exchanges (per cent)"]
["Year/ Month","BSE",null,null,null,null,"NSE",null,null,null,null,"MSEI"]
["Top","5","10","25","50","100","5","10","25","50","100","5","10","25","50","100"]
["Securities"]
["2019-20",15.961600000000001,24.4329,39.517400000000002,52.518500000000003,68.082899999999995,15.55,26.32,45.68,60.58,77.92,97.15,99.99,100,100,100]
["2020-21$",17.610199999999999,27.709099999999999,43.566499999999998,55.955500000000001,70.482200000000006,19.059999999999999,29.21,47.33,63.19,79.45,100,100,100,100,100]
["Apr-20",18.805700000000002,29.1358,45.223100000000002,60.204700000000003,76.281199999999998,21.74,34.01,53.29,68.599999999999994,84.6,100,100,100,100,100]
["May-20",41.5822,51.138599999999997,63.966799999999999,74.109499999999997,84.837299999999999,24.02,36.799999999999997,53.22,69.14,85.35,0,0,0,0,0]
["Jun-20",33.7851,44.357500000000002,58.000900000000001,68.317999999999998,79.692300000000003,20.48,31.24,49.55,64.86,81.069999999999993,100,100,100,100,100]
["Jul-20",18.940300000000001,27.986699999999999,43.064300000000003,56.372599999999998,70.902100000000004,24.22,34.54,50.06,65.400000000000006,80.58,100,100,100,100,100]
["Aug-20",23.159199999999998,30.7546,42.8767,54.628799999999998,68.464500000000001,16.95,26.42,42.83,58.74,75.290000000000006,100,100,100,100,100]
["2020-09-01",15.774100000000001,23.506799999999998,38.415900000000001,52.5471,69.154799999999994,18.53,27.89,46.55,62.92,78.819999999999993,100,100,100,100,100]
["Oct-20",15.1569,24.3018,42.322899999999997,56.286900000000003,72.004099999999994,17.100000000000001,27.87,48.87,64.83,81.760000000000005,100,100,100,100,100]
["Nov-20",16.3218,25.544499999999999,42.485500000000002,55.781700000000001,70.873400000000004,19.34,30.94,47.95,63.57,80.61,100,100,100,100,100]
["Members"]
["2019-20",26.49,40.159999999999997,64.55,76.040000000000006,85.83,25.48,39.020000000000003,59.55,75.87,87.66,80.36,100,100,100,100]
["2020-21$",34.51,50.16,70.13,80.89,89.16,30.56,43.39,63.65,78.72,89.54,100,100,100,100,0]
["Apr-20",32.94,49.91,71.44,82.7,91.2,30.67,44.88,65.510000000000005,80.709999999999994,90.92,100,100,100,100,0]
["May-20",42.92,56.43,76.25,85.01,91.92,30.67,44.2,64.59,80.209999999999994,90.67,0,0,0,0,0]
["Jun-20",45.78,60.7,77.42,85.46,92.1,30.73,45.25,64.84,78.89,89.48,100,100,100,100,0]
["Jul-20",40.35,55.93,71.569999999999993,80.84,88.93,32.21,45.3,64.28,77.55,88.45,100,100,100,100,0]
["Aug-20",32.85,46.38,68.19,79.760000000000005,88.9,31.57,44.29,63.23,77.44,88.4,100,100,100,100,0]
["2020-09-01",35.65,50.01,70.849999999999994,81.849999999999994,90.23,31.67,45.84,65.91,79.739999999999995,89.92,100,100,100,100,0]
["Oct-20",39.700000000000003,53.61,71.06,80.39,88.93,31.18,45.15,64.98,79.849999999999994,90.41,100,100,100,100,0]
["2020-11-01",39.72,55.55,72.06,82.1,89.91,29.09,41.81,64.64,80.41,90.7,100,100,100,100,0]
["Notes: 1. Data for Top N scrips has been compiled for all markets except auction market & retail debt market and includes series EQ, BE,BT, BL and IL."]
["$ indicates as on November 30, 2020"]
["Source: BSE, NSE and MSEI."]

{"sheet":"31","index":31,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,8],[12,0,12,6],[13,0,13,3],[14,0,14,3]]}
["Table 31: Settlement Statistics for Cash Segment of ICCL"]
["Year /  Month","No. of Trades (lakh)","Traded Quantity   (lakh)","Delivered Quantity   (lakh)","Delivered Quantity to Traded Quantity (per cent)","Turnover (₹ crore)","Delivered Value   (₹ crore)","Delivered Value to Total Turnover (per cent)","Delivered Quantity in Demat Mode (lakh)","Demat Delivered Quantity to Total Delivered Quantity (per cent)","Delivered Value in Demat Mode     (₹ crore)","Demat Delivered Value to Total Delivered Value (per cent)","Short Delivery (Auctioned quantity) (lakh)","Short Delivery to Delivered Quantity (per cent)","Funds Pay-in (₹ crore)","Securities Pay-in (₹ crore)","Settlement Guarantee Fund (₹  crore)"]
["2019-20",3210.1607600000002,555304,204312.50842,{"$f":"D3/C3*100","v":36.792911345857405},672464.22,193663.12298489001,{"$f":"G3/F3*100","v":28.79902264315119},171221.4999,{"$f":"I3/D3*100","v":83.803728525531255},193243.43338827,{"$f":"K3/G3*100","v":99.78328884190681},369.15190000000001,{"$f":"M3/D3*100","v":0.18068002926240026},61952.6980559,193935.17293415,223.1]
["2020-21$",{"$f":"SUM(B5:B12)","v":3379.7},{"$f":"SUM(C5:C12)","v":593940.6},{"$f":"SUM(D5:D12)","v":170807.70486},{"$f":"D4/C4*100","v":28.758381706857556},{"$f":"SUM(F5:F12)","v":588818},{"$f":"SUM(G5:G12)","v":160072.31442000001},{"$f":"G4/F4*100","v":27.185363630187936},{"$f":"SUM(I5:I12)","v":170807.71137999996},{"$f":"I4/D4*100","v":100.00000381715799},{"$f":"SUM(K5:K12)","v":160072.31442000001},{"$f":"K4/G4*100","v":100},{"$f":"SUM(M5:M12)","v":404.07032999999996},{"$f":"M4/D4*100","v":0.23656446313776663},{"$f":"SUM(O5:O12)","v":36171},{"$f":"SUM(P5:P12)","v":160272},{"$f":"Q12","v":233.9}]
["Apr-20",339,37309,11926.5,31.966817657937764,44040,13145,29.847865576748411,11926.5,100,13145,100,30.3,0.25405609357313547,3609,13162,224.38]
["May-20",316.2,46869,14976.3,31.953530051846634,63127,14218,22.522850761164005,14976.3,100,14218,100,30.3,0.20231966507081189,4598,14230,225.71]
["Jun-20",543.20000000000005,108007.6,28084.9,26.002707216899552,109738,22839,20.812298383422334,28084.9,100,22839,100,59.4,0.21150155421596656,5227,22864,115.15]
["Jul-20",518.29999999999995,100445,30648.58,30.512798048683358,80053,23567,29.439246499194283,30648.6,100.00006525587808,23567,100,134.4,0.43851950074032792,4656,23596,228.38]
["Aug-20",471.9,93649,27994.7,29.893218293841901,90938,25780,28.348985022762761,27994.7,100,25780,100,45.8,0.16360239616784605,4505,25812,229.69]
["2020-09-01",427.4,87230,20728.811379999999,23.763397202797201,73748,21778.314419999999,29.530718690676355,20728.811379999999,100,21778.314419999999,100,31.470330000000001,0.15181926943656721,4968,21819,231.16]
["Oct-20",343.2,52086,14433.4,27.710709211688361,54904,16803,30.604327553548011,14433.4,100,16803,100,43.9,0.30415563900397685,3490,16828,232.51]
["Nov-20",420.5,68345,22014.513480000001,32.21086177481893,72270,21942,30.361145703611459,22014.5,99.999938767667913,21942,100,28.5,0.12946004928018057,5118,21961,233.9]
["Note:"]
["$ indicates as on November 30,2020"]
["Source: ICCL"]

{"sheet":"32","index":32,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,8],[12,0,12,6],[14,0,14,6],[15,0,15,6]]}
["Table 32: Settlement Statistics for Cash Segment of NCL"]
["Year /  Month","No. of Trades (lakh)","Traded Quantity   (lakh)","Delivered Quantity   (lakh)","Delivered Quantity to Traded Quantity (per cent)","Turnover (₹ crore)","Delivered Value   (₹ crore)","Delivered Value to Total Turnover (per cent)","Delivered Quantity in Demat Mode (lakh)","Demat Delivered Quantity to Total Delivered Quantity (per cent)","Delivered Value in Demat Mode     (₹ crore)","Demat Delivered Value to Total Delivered Value (per cent)","Short Delivery (Auctioned quantity) (lakh)","Short Delivery to Delivery Quantity (per cent)","Funds Pay-in (₹ crore)","Securities Pay-in (₹ crore)","Settlement Guarantee Fund (₹  crore)"]
["2019-20",35768.935709999998,5361647.5389999999,1067585.125,19.911512590000001,9643316.7670000009,2077333.0319999999,21.54168615,1065619.0109999999,{"$f":"I3/D3*100","v":99.815835388302162},2075912.925,{"$f":"K3/G3*100","v":99.931637971469954},1966.104961,0.18450355500000001,600587.1226,2077333.0319999999,302.11]
["2020-21$",{"$f":"SUM(B5:B16)","v":35093.957049999997},{"$f":"SUM(C5:C16)","v":5482614.7439000001},{"$f":"SUM(D5:D16)","v":935843.35798000009},{"$f":"D4/C4*100","v":17.069289047187326},{"$f":"SUM(F5:F16)","v":10118901.335999999},1755169.6783999999,{"$f":"G4/F4*100","v":17.345456983117678},933899.33905999991,{"$f":"I4/D4*100","v":99.792270906939351},1754052.3624,{"$f":"K4/G4*100","v":99.936341425347635},1944.0290400000001,{"$f":"M4/D4*100","v":0.20773017443818262},510519.41000000003,1755169.6783999999,{"$f":"Q12","v":332.28}]
["Apr-20",4150.2334300000002,468098.45819999999,86142.43144,18.40263088,926064.65599999996,169258.2064,18.277147849999999,85960.241169999994,99.788501128939103,169154.07440000001,99.938477429121576,182.19027,0.21194713700000001,53768.75,169258.2064,305.51]
["May-20",3967.3101900000001,519841.9523,90797.839619999999,17.466431709999998,1049727.142,201623.16380000001,19.207197359999999,90650.955839999995,99.838229873513811,201524.13329999999,99.950883371665441,146.88378,0.16177012599999999,80224.740000000005,201623.16380000001,311.04000000000002]
["Jun-20",5341.7662899999996,1030660.0110000001,155158.89689999999,15.054323950000001,1520003.977,249841.2941,16.43688423,154762.5999,99.744586351206536,249657.12940000001,99.926287325454581,396.29710999999998,0.25606775199999998,75290.960000000006,249841.2941,314.77999999999997]
["Jul-20",4814.26847,805230.80790000001,131916.69380000001,16.382469780000001,1414639.284,229927.28049999999,16.25342114,131411.98749999999,99.617405284000512,229766.37590000001,99.930019352357817,504.70627999999999,0.38259473900000002,56586.18,229927.28049999999,316.97000000000003]
["Aug-20",4483.88429,756614.81169999996,138718.49950000001,18.334097799999999,1339265.102,229893.01019999999,17.165608949999999,138575.89129999999,99.897195975652821,229745.5386,99.935852073157122,142.60824,0.10280405300000001,55195.16,229893.01019999999,320.88]
["Sep-20",4506.4092099999998,781188.5871,123886.25689999999,15.858687509999999,1386253.895,235653.72029999999,16.999318890000001,123617.95080000001,99.783425452738825,235469.04939999999,99.921634634172165,268.30608999999998,0.217044603,64749.96,235653.72029999999,326.93]
["Oct-20",3602.69517,487624.50569999998,84937.629820000002,17.418654889999999,1110638.7139999999,188341.83309999999,16.957974790000002,84770.602549999996,99.803353036393915,188226.22140000001,99.938616026988228,167.02726999999999,0.19664696400000001,47858.76,188341.83309999999,329.18]
["Nov-20",4227.3900000000003,633355.61,124285.11,19.62,1372308.5660000001,250631.17,18.26347049,124149.11,99.8905741806078,250509.84,99.951590219205372,136.01,0.11,76844.899999999994,250631.17,332.28]
["Notes:"]
["1.  Settlement Statistics for settlement type N, excluding CM Series IL & BL"]
["$ indicates as on November 30,2020"]
["Source: NCL"]

{"sheet":"33","index":33,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,14],[14,0,14,14]]}
["Table 33: Settlement Statistics for Cash Segment of MCCIL"]
["Month Sorting","No. of Trades (Lakh)","Traded Quantity (Lakh)","Delivered Quantity   (Lakh)","Delivered Quantity to Traded Quantity (per cent)","Turnover (₹ crore)","Delivered Value      (₹ crore)","Delivered Value to Total Turnover (per cent)","Delivered Quantity in Demat Mode (Lakh)","Demat Delivered Quantity to Total Delivered Quantity (per cent)","Delivered Value in Demat Mode     (₹ crore)","Demat Delivered Value to Total Delivered Value (per cent)","Funds Pay-in (₹ crore)","Securities Pay-in (₹ crore)","Settlement Guarantee Fund(₹ crore)"]
["2019-20",5.64E-3,10.29321,10.291169999999999,99.98,20.302788339999999,20.301970449999999,100,10.291169999999999,100,20.301970449999999,100,20.301970449999999,20.301970449999999,0.35]
["2020-21$",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Apr-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["May-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Jun-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Jul-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Aug-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Sep-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Oct-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Nov-20",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Note:"]
["$ indicates as on November 30,2020"]
["Source: MCCIL"]

{"sheet":"34","index":34,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,9],[0,0,0,17],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5],[1,6,1,9],[1,10,1,13],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[14,0,14,9],[16,0,16,9]]}
["Table 34: Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value) "]
["Year/     Month","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of Month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\ncontracts","Turnover\n(₹ crore)"]
["2019-20",247,150212,14933.63792825,2983,162.96255754500001,2032161,200440.05508463,480178,45522.520567375002,8473,626.10800537499995,7876,583.24307475000001,2681883,262268.51721791999,515,37.94]
["2020-21$",{"$f":"SUM(B7:B18)","v":166},42736,3801.892884375,0,0,72985787,7155706.5203595003,72470871,6015748.905755071,0,0,0,0,145499394,13175257.3089989,{"$f":"Q14","v":4575},{"$f":"R14","v":1393.761054375}]
["Apr-20",18,962,77.77,0,0,995903,87578.38,309028,21493.72,0,0,0,0,1305893,109149.87,2407,202.9]
["May-20",19,4144,326.38,0,0,1218595,107799.6,142492,9623.57,0,0,0,0,1365231,117749.55,971,78.709999999999994]
["Jun-20",22,1747,145.84,0,0,106,8.98,0,0,0,0,0,0,1853,154.82,81,6.54]
["Jul-20",23,7735,663.89,0,0,3256827,297616.75,3893948,304232.15000000002,0,0,0,0,7158510,602512.78,4045,352.49]
["Aug-20",21,6025,536.5,0,0,11023986,1047508,10361093,800072.42,0,0,0,0,21391104,1848116.92,8217,735.07]
["2020-09-01",22,8832,786.64434974999995,0,0,20820481,1992957.1291642999,8975662,732822.87558186997,0,0,0,0,29804975,2726566.6490958999,3589,318.18584564999998]
["Oct-20",21,7543,699.61081987499995,0,0,17657324,1740130.1174258001,20007431,1651682.5274876,0,0,0,0,37672298,3392512.2557333,3842,351.4300452]
["Nov-20",20,5748,565.25771474999999,0,0,18012565,1882107.5637693999,28781217,2495821.6426856001,0,0,0,0,46799530,4378494.4641696997,4575,1393.761054375]
["Notes: "]
["1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on November 30,2020"]
["Source: BSE."]

{"sheet":"35","index":35,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5],[1,6,1,9],[1,10,1,13],[14,0,14,17],[17,0,17,17],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
["Table 35: Trends in Equity Derivatives Segment at NSE (Turnover in Notional Value) "]
["Year/     Month","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of Month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)"]
["2019-20",247,94472538,6677312.0489999996,256643910,14874729.23,2480471005,169696653.69999999,2095899292,140995315.59999999,125587962,8003236.6960000005,72247170,4285644.5180000002,5125321877,344532891.80000001,3162958,163121.89000000001]
["2020-21$",{"$f":"SUM(B7:B19)","v":166},{"$f":"SUM(C7:C19)","v":92955101},5799564.4844000004,172377584,11106430.104600001,2446385348,157515456.94,2181951050,136899998.33899999,128578955,9634234.999400001,63315514,4260190.9057999998,5085563552,325215875.77000004,{"$f":"Q14","v":4595869},{"$f":"R14","v":384434.03}]
["Apr-20",18,11339332,594715.51879999996,19476580,954968.99560000002,194547845,10077297.859999999,170934639,8385702.6540000001,8039630,446624.89990000002,4593986,224068.50750000001,408932012,20683378.43,2874264,170257.67]
["May-20",19,12843909,640625.01850000001,22573353,1118023.5830000001,247931778,12205317.18,211059297,9947263.2349999994,10850597,613231.52850000001,6115405,307470.4877,511374339,24831931.030000001,3707494,207782.64]
["Jun-20",22,15478384,859740.79729999998,26276560,1455365.7320000001,315751153,17914117.940000001,274665301,14986695.93,16288049,1004821.518,8934064,489038.42219999997,657393511,36709780.340000004,4366903,287861.11]
["Jul-20",23,11772248,777191.33360000001,22710216,1574937.3559999999,352353120,21236714.829999998,306566670,18239374.289999999,18843923,1466518.213,8956614,640972.45660000003,721202791,43935708.490000002,4086465,295273.53000000003]
["Aug-20",21,9211071,621182.59080000001,20582172,1478175.953,272955256,18650461.920000002,248776124,16724302.85,17535138,1370741.004,8110037,584505.17619999999,577169798,39429369.490000002,4589201,340564.43]
["Sep-20",22,11161701,740669.28419999999,20622408,1535447.6340000001,335641868,22765319.579999998,306427676,20183965.609999999,18581654,1577042.183,8457379,652074.08499999996,700892686,47454518.380000003,5135777,370433.46]
["Oct-20",21,10631893,739099.33589999995,19384435,1446063.754,382280696,27046687.93,346958115,23856847.190000001,18552773,1545489.7760000001,8585986,647436.28520000004,786393898,55281624.270000003,4190150,306997.98]
["Nov-20",20,10516563,826340.60530000005,20751860,1543447.0970000001,344923632,27619539.699999999,316563228,24575846.579999998,19887191,1609765.8770000001,9562043,714625.48540000001,722204517,56889565.340000004,4595869,384434.03]
["Notes: "]
["1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on November 30,2020"]
["Source: NSE."]

{"sheet":"36","index":36,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,0,15,3],[16,0,16,3],[17,0,17,3],[0,0,0,12],[2,0,4,0],[2,1,2,6],[2,7,2,12],[3,1,3,2],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,3,8],[3,9,3,10],[3,11,4,11],[3,12,4,12]]}
["Table 36: Settlement Statistics in Equity Derivatives Segment "]
[null,null,null,null,null,null,null,null,null,null,null,null," (₹ crore)"]
["Year/     Month","BSE",null,null,null,null,null,"NSE"]
[null,"Index/Stock\nFutures",null,"Index/Stock\nOptions",null,"Total","Settlement\nGurantee\nFund","Index/Stock\nFutures",null,"Index/Stock\nOptions",null,"Total","Settlement\nGurantee\nFund"]
[null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement",null,null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement"]
["2019-20",1778.49,95.27,1165.5999999999999,10.91,{"$f":"SUM(B6:E6)","v":3050.2699999999995},21.81,13384.326666667001,188.74,2131.8208333329999,532.07166666700004,{"$f":"SUM(H6:K6)","v":16236.959166667},2211.84]
["2020-21$",{"$f":"SUM(B8:B18)","v":3286.78},{"$f":"SUM(C8:C18)","v":88.39},{"$f":"SUM(D8:D18)","v":17182.400000000001},{"$f":"SUM(E8:E18)","v":35.120000000000005},{"$f":"SUM(B7:E7)","v":20592.689999999999},{"$f":"G15","v":23.52},{"$f":"SUM(H8:H18)","v":93172.14},{"$f":"SUM(I8:I18)","v":1348.82},{"$f":"SUM(J8:J18)","v":18160.68},{"$f":"SUM(K8:K18)","v":3682.7000000000007},{"$f":"SUM(H7:K7)","v":116364.34000000001},{"$f":"M15","v":2405.56}]
["Apr-20",135.52000000000001,5.79,173.72,1.8,{"$f":"SUM(B8:E8)","v":316.83},21.93,15832.02,370.66,1809.08,431.1,18442.86,2231.7399999999998]
["May-20",123.84,4.07,197.23,0.84,325.97999999999996,22.07,12028.16,187.57,1889.56,261.08999999999997,14366.38,2244.09]
["Jun-20",179.15,2.75,299.07,2.62,483.59000000000003,22.3,12911.59,74.19,2510.98,494.02,15990.78,2268.39]
["Jul-20",399.43,13.89,2411.5500000000002,7.16,2832.03,22.56,12046.91,117.66,2450.4899999999998,478.65,15093.71,2283.2600000000002]
["Aug-20",538.19000000000005,9.34,2814.84,3.41,3365.78,22.84,8945.99,71.53,2028.28,367.69,11413.490000000002,2309.02]
["Sep-20",730.73,25.69,3422.68,3.88,4182.9800000000005,23.05,11829.12,368.53,2499.11,373.22,15069.980000000001,2341.41]
["Oct-20",472.78,5.3,3723.07,6.92,4208.0700000000006,23.27,8658.34,76.180000000000007,2445.66,531.69000000000005,11711.87,2374.6]
["Nov-20",707.14,21.56,4140.24,8.49,4877.4299999999994,23.52,10920.01,82.5,2527.52,745.24,14275.27,2405.56]
["Note: "]
["$ indicates as on November 30, 2020"]
["Source: ICCL and NCL"]

{"sheet":"37","index":37,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,10],[0,0,0,10],[1,0,2,0],[1,1,1,5],[1,6,1,10],[14,0,14,10]]}
["Table 37: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Year/Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FPI","Mutual Funds","Banks","Others","Pro","FPI","Mutual Funds","Banks","Others"]
["2019-20",85.567661444448788,5.581012084640017E-2,0,0,14.37652843470482,52.91,0,0,0,47.09]
["2020-21$",92.926473885990106,2.3237160488887213E-5,0,0,7.0735028768494468,94.994535518999996,0,0,0,5.0054644809999997]
["Apr-20",99.979961365693697,0,0,0,2.00386343063069E-2,49.89,0,0,0,50.11]
["May-20",99.918515308384897,0,0,0,8.1484691615015994E-2,74.459999999999994,0,0,0,25.54]
["Jun-20",68.205065649142099,0.10456339878613399,0,0,31.690370952071699,50,0,0,0,50]
["Jul-20",93.087095327091703,0,0,0,6.9129046729082599,84.4,0,0,0,15.6]
["Aug-20",92.330861156359902,3.1682634339132097E-5,0,0,7.66910716100569,72.78,0.01,0,0,27.21]
["Sep-20",86.753122976935302,4.1550112130054198E-5,0,0,13.246835472952499,97.548063526999996,0,0,0,2.4519364729999999]
["Oct-20",94.548673316615506,2.7489196934335998E-6,0,0,5.4513239344647699,94.234773555000004,0,0,0,5.7652264449999997]
["Nov-20",95.380133984746394,2.4848429840513701E-5,0,0,4.61984116682373,94.994535518999996,0,0,0,5.0054644809999997]
["Note:"]
["$ indicates as on November 30,2020"]
["Source: BSE."]

{"sheet":"38","index":38,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,10],[0,0,0,10],[1,0,2,0],[1,1,1,5],[1,6,1,10],[14,0,14,10]]}
["Table 38: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Year/Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FPIs","Mutual Funds","Banks","Others","Pro","FPIs","Mutual Funds","Banks","Others"]
["2019-20",33.19,19.25,0.28999999999999998,0,47.27,11.46,30.9,15.99,0,41.65]
["2020-21$",38.869999999999997,14.17,0.18,0,46.78,17.059999999999999,24.26,9.35,0,49.33]
["Apr-20",32.369999999999997,17.2,0.28999999999999998,0,50.14,11.99,33.979999999999997,15.95,0,38.08]
["May-20",34.69,17.84,0.28999999999999998,0,47.18,14.18,29.9,15.22,0,40.700000000000003]
["Jun-20",35.22,18.45,0.22,0,46.11,17.14,24.27,10.68,0,47.91]
["Jul-20",36.39,15.77,0.17,0,47.67,16.760000000000002,24.26,10.94,0,48.04]
["Aug-20",40.1,12.72,0.18,0,46.99,18.71,23.37,9.2200000000000006,0,48.7]
["Sep-20",41.45,12.18,0.15,0,46.22,17.78,20.68,8.31,0,53.23]
["Oct-20",41.52,11.74,0.12,0,46.61,16.46,24.24,10.47,0,48.83]
["Nov-20",41.76,12.5,0.14000000000000001,0,45.6,17.059999999999999,24.26,9.35,0,49.33]
["Note:"]
["$ indicates as on November 30,2020"]
["Source: NSE."]

{"sheet":"39","index":39,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[14,0,14,5],[15,0,15,3]]}
["Table 39: Instrument-wise Turnover in Index Derivatives at BSE"]
["(per cent)"]
["Year/Month","BSE 30 SENSEX","BSE SENSEX 50","BSE BANKEX"]
["2019-20",100,0,0]
["2020-21$",2.8156497620464758,97.184350237953524,0]
["Apr-20",100,0,0]
["May-20",100,0,0]
["Jun-20",16.84,83.16,0]
["Jul-20",0,100,0]
["Aug-20",0,100,0]
["2020-09-01",0,100,0]
["Oct-20",0,100,0]
["Nov-20",0,100,0]
["Note:"]
["$ indicates as on November 30,2020"]
["Source: BSE."]

{"sheet":"40","index":40,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[14,0,14,3],[15,0,15,3]]}
["Table 40: Instrument-wise Turnover in Index Derivatives at NSE"]
[" (per cent)"]
["Year/Month","NIFTY","NIFTYIT","BANKNIFTY"]
["2019-20",39.006821029999998,9.5086300000000003E-4,60.992228109999999]
["2020-21$",47.282699999999998,1E-4,52.717199999999998]
["Apr-20",49.588625409999999,3.1785899999999998E-4,50.411056729999999]
["May-20",46.989811170000003,2.1736600000000001E-4,53.009971460000003]
["Jun-20",54.365526439999996,1.2704099999999999E-4,45.634346520000001]
["Jul-20",49.938886799999999,0,50.061113200000001]
["Aug-20",49.84197013,0,50.15802987]
["Sep-20",47.363995090000003,0,52.636004909999997]
["Oct-20",45.152463480000002,0,54.847536519999998]
["Nov-20",40.323999999999998,0,59.676000000000002]
["Note:"]
["$ indicates as on November 30, 2020"]
["Source: NSE."]

{"sheet":"41","index":41,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,11],[18,0,18,11],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,1,7],[1,8,2,9],[1,10,2,11],[2,4,2,5],[2,6,2,7]]}
["Table 41: Trends in Currency Derivatives Segment at BSE"]
["Year/ Month","No. of Trading Days","Currency Futures",null,"Currency  Options",null,null,null,"Total",null,"Open Interest at the end of  the Month**"]
[null,null,null,null,"Call",null,"Put"]
[null,null,"No. of Contracts","Turnover (₹ crore)","No. of Contracts","Turnover (₹ crore)","No. of Contracts ","Turnover (₹ crore)","No. of Contracts","Turnover * (₹ crore)","No. of Contracts ","Value \n(₹ crore)"]
["2019-20",243,400927037,2852910.86,214693422,1538428.304,328897100,2291934.5920000002,944517559,6683273.7560000001,2288248,17251.47]
["2020-21$",{"$f":"SUM(B7:B19)","v":163},176960089,1325744.0174000002,96955496,739257.81670000008,150875399,1109104.2677,424790984,3174106.1118000001,{"$f":"K14","v":950779},{"$f":"L14","v":7083.3784750000004}]
["Apr-20",17,18156395,138820.29,6476787,50460.69,10892155,81863.399999999994,35525337,271144.38,1273915,9570.3700000000008]
["May-20",18,17436081,132222.54999999999,9017175,69915.06,14011006,104007.3,40464262,306144.90000000002,678398,5151.87]
["Jun-20",22,23756034,180393.67,15910793,123085.45,21994582,163766.07,61661409,467245.2,712652,5394.75]
["Jul-20",23,25338836,190382.76,10697892,81976.56,22387440,164807.01,58424168,437166.34,639219,4839.72]
["Aug-20",21,22489598,168111.03,17886515,136249.15,20029214,147430.07999999999,60405327,451790.26,806498,5966.81]
["Sep-20",22,25789498,189948.5215,14614903,109555.8563,17967576,129973.0131,58371977,429477.3909,1051011,7777.820635]
["Oct-20",20,21085186,155309.52780000001,11320525,84755.885800000004,23298862,168825.3352,55704573,408890.7488,789087,5854.0947080400001]
["Nov-20",20,22908461,170555.66810000001,11030906,83259.164600000004,20294564,148432.0594,54233931,402246.8921,950779,7083.3784750000004]
["Note:"]
["1. * Notional Turnover"]
["2. ** OI data is at BSE level."]
["$ indicates as on November 30,2020"]
["Source: BSE"]

{"sheet":"42","index":42,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,1,3],[1,4,1,7],[1,8,1,9],[1,10,1,11],[2,2,3,2],[2,3,3,3],[2,4,2,5],[17,0,17,11],[18,0,18,11],[2,6,2,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[14,0,14,11]]}
["Table 42: Trends in Currency Derivatives Segment at NSE"]
["Year/     Month","No. of Trading  Days","Currency Futures",null,"Currency Options",null,null,null,"Total",null,"Open Interest at the\nend of Month*"]
[null,null,"No. of\nContracts","Turnover\n(₹ crore)","Call",null,"Put",null,"No. of Contracts ","Turnover (₹ crore)","No. of\nContracts","Value\n(₹ crore)"]
[null,null,null,null,"No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)"]
["2019-20",243,660128849,4806639.4400000004,352374185,2520679.83,327759150,2327074.4989999998,1340262184,9654393.7679999992,6826565,51810.079769999997]
["2020-21$",{"$f":"SUM(B7:B19)","v":163},462612921,3594184.1133999997,265513920,1996030.3753,244899945,1826879.1589000002,973026786,7417093.6480999999,{"$f":"K14","v":5694357},{"$f":"L14","v":43011.455580000002}]
["Apr-20",17,48012637,372205.46909999999,22067309,169628.2971,20327816,154448.6911,90407762,696282.45719999995,4263641,32203.754280000001]
["May-20",18,47443900,367808.5477,26027374,198497.3371,21602048,163221.3511,95073322,729527.23580000002,3650637,27865.660650000002]
["Jun-20",22,58286091,456224.96409999998,34559311,263411.82620000001,30334567,229533.27929999999,123179969,949170.06960000005,4593310,35033.710249999996]
["Jul-20",23,55160793,429355.04470000003,35967687,271284.10320000001,32389301,242756.524,123517781,943395.67189999996,4149989,31789.242910000001]
["Aug-20",21,57090417,447196.38219999999,36908748,276899.21950000001,33912469,252768.72779999999,127911634,976864.32949999999,5261518,39274.370020000002]
["Sep-20",22,70415755,543128.39760000003,40102425,296868.95429999998,38109897,280076.2378,148628077,1120073.5900000001,5393259,40182.189149999998]
["Oct-20",20,60003856,463941.2597,36269425,268329.96460000001,33365914,245397.05780000001,129639195,977668.28209999995,4976914,37495.171690000003]
["Nov-20",20,66199472,514324.04830000002,33611641,251110.67329999999,34857933,258677.29,134669046,1024112.012,5694357,43011.455580000002]
["Notes: "]
["1. Trading Value :- For Futures, Value of contract = Traded Qty*Traded Price. 2. For Options, Value of contract = Traded Qty*(Strike Price+Traded Premium)"]
["2. *Open Interest provided in Table No. 42 is at NSE Clearing Limited level, while in Table 46 it is at NSE Level. Hence, the difference in number/value between the two tables."]
["$ indicates as on November 30,2020"]
["Source: NSE."]

{"sheet":"43","index":43,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,11,3,11],[15,0,15,9],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,1,3],[1,4,1,7],[1,8,1,9],[1,10,1,11],[2,2,3,2],[2,3,3,3],[2,4,2,5],[16,0,16,9],[2,6,2,7],[2,8,3,8],[2,9,3,9],[2,10,3,10]]}
["Table 43: Trends in Currency Derivatives Segment at MSEI"]
["Year/     Month","No. of Trading  Days","Currency Futures",null,"Currency Options",null,null,null,"Total",null,"Open Interest at the\nend of Month"]
[null,null,"No. of\nContracts","Turnover\n(₹ crore)","Call",null,"Put",null,"No. of Contracts ","Turnover (₹ crore)","No. of\nContracts","Value\n(₹ crore)"]
[null,null,null,null,"No. of\nContracts","Turnover\n(₹ crore)","No. of\nContracts","Turnover\n(₹ crore)"]
["2019-20",243,5783785,41521.070337750003,234838,1757.805652,273575,2045.6429625000001,6292198,45324.51895225,6073,45.977366000000004]
["2020-21$",{"$f":"SUM(B7:B17)","v":163},5901826,43959.142632000003,2461,18.75042925,3918,28.414354249999999,5908205,44006.307415499999,{"$f":"K14","v":42379},{"$f":"L14","v":320.41322150000002}]
["Apr-20",17,233754,1785.2814207500001,0,0,0,0,233754,1785.2814207500001,22075,166.24752325]
["May-20",18,224568,1702.42343375,0,0,0,0,224568,1702.42343375,9679,73.879713749999993]
["Jun-20",22,375979,2854.2512265,0,0,0,0,375979,2854.2512265,15683,119.16822025]
["Jul-20",23,537915,4042.2201822500001,565,4.2009162499999997,2500,18.001124999999998,540980,4064.4222235000002,13180,99.837251749999993]
["Aug-20",21,706873,5291.3987129999996,0,0,0,0,706873,5291.3987129999996,14445,106.699082]
["Sep-20",22,934628,6884.9063724999996,500,3.7099250000000001,0,0,935128,6888.6162974999997,18028,134.462391]
["Oct-20",20,1232325,9067.6227062500002,530,4.40069,429,3.1778697500000002,1233284,9075.201266,12722,95.381641999999999]
["Nov-20",20,1655784,12331.038576999999,866,6.438898,989,7.2353595000000004,1657639,12344.7128345,42379,320.41322150000002]
["Note:"]
["$ indicates as on November 30, 2020"]
["Source: MSEI"]

{"sheet":"44","index":44,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,14],[2,0,4,0],[2,1,2,4],[2,5,4,5],[2,6,2,9],[2,10,4,10],[2,11,2,14],[16,0,16,14],[17,0,17,14],[2,15,4,15],[3,1,3,2],[3,3,3,4],[3,6,3,7],[3,8,3,9],[3,11,3,12],[3,13,3,14]]}
["Table 44: Settlement Statistics of Currency Derivatives Segment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," (₹ crore)"]
["Year/     Month","BSE",null,null,null,"Total","NSE",null,null,null,"Total","MSEI",null,null,null,"Total"]
[null,"Currency\nFutures",null,"Currency Options",null,null,"Currency\nFutures",null,"Currency Options",null,null,"Currency\nFutures",null,"Currency Options"]
[null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement",null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement",null,"MTM\nSettlement","Final\nSettlement","Premium\nSettlement","Exercise\nSettlement"]
["2019-20",7222.5,246.08,5002.79,76.14,12547.51,9038.7684582069996,266.00635390000002,1351.72486134,553.36033283999996,11209.860006286999,95.838627000000002,6.3884942999999996,3.8640000000000001E-2,1.0989999999999999E-3,102.2668603]
["2020-21$",{"$f":"SUM(B8:B18)","v":3879.88},{"$f":"SUM(C8:C18)","v":71.180000000000007},3269.65,70.39,7291.0999999999995,4765.1435075179998,83.094966559999989,813.64458837000006,263.89861643,5925.7816788779992,64.515655500000008,3.5296399999999997,0,0,68.045295500000009]
["Apr-20",1122.19,12.14,322.02999999999997,8.34,1464.7,1732.109531028,17.211897870000001,118.462208,30.032362689999999,1897.8159995880001,7.94,0.317,0,0,8.2569999999999997]
["May-20",457.51,4,312.08999999999997,3.94,777.54,555.48637647999999,4.4865100900000003,79.326992250000004,16.697893109999999,655.99777193,12.65,0.08,0,0,12.73]
["Jun-20",288.39999999999998,4.17,334.02,4.12,630.71,360.42006702999998,6.8948276499999999,89.082384500000003,23.39430685,479.79158603000002,6.3867542500000001,0.75900000000000001,0,0,7.1457542500000004]
["Jul-20",371.52,5.94,417.16,12.75,807.37,459.97380621999997,9.0436626400000009,95.182137499999996,52.270053939999997,616.46966029999999,4.2533475000000003,0.35235,0,0,4.6056975000000007]
["Aug-20",475.56,6.14,387.25,6.53,875.48,461.19636310999999,6.2852173699999998,97.782923620000005,27.036283709999999,592.30078780999997,16.86103975,0.43604999999999999,0,0,17.297089750000001]
["Sep-20",394.99,6.53,520.28,9.3699999999999992,931.17,359.49221784000002,8.2159539600000002,119.67712975000001,34.743132070000001,522.12843362000001,5.9990617500000001,0.2984,0,0,6.2974617500000001]
["Oct-20",418.49,23.89,448.51,12.54,903.43,422.60093712999998,23.103885819999999,100.06898875,38.28261217,584.05642387,2.1147982500000002,0.79139999999999999,0,0,2.9061982500000001]
["Nov-20",351.22,8.3699999999999992,528.30999999999995,12.8,900.7,413.86420867999999,7.8530111600000003,114.061824,41.441971889999998,577.22101572999998,8.3106539999999995,0.49543999999999999,0,0,8.8060939999999999]
["Note:"]
["$ indicates as on November 30, 2020"]
["Source: ICCL, NCL and MCCIL."]

{"sheet":"45","index":45,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,8],[17,0,17,8],[0,0,0,8],[1,0,2,0],[1,1,1,7],[1,8,1,14],[14,0,14,8],[15,0,15,8]]}
["Table 45: Instrument-wise Turnover in Currency Derivatives Segment of BSE"]
["Year/Month","Turnover* (₹ crore)",null,null,null,null,null,null,"Open Interest as on last day of the month **"]
[null,"USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY","USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY"]
["2019-2020",6677486.4557837499,1792.5447275000001,2170.68146725,1823.7525047500001,9.3858817378999995E-2,3.7072608659E-2,0.16362095999999998,2270484,7992,338,9434,0,0,0]
["2020-21$",3167237.7575282501,2967.3113732500005,3252.9915367500003,648.03423724999993,0,0,0,912871,14157,19243,4508,0,0,0]
["2020-04-13",270845.70071050001,96.073722750000002,126.9456955,75.655298999999999,0,0,0,1271120,1045,646,1104,0,0,0]
["2020-05-14",305507.92691849999,318.09564749999998,229.198891,89.679657500000005,0,0,0,652421,20386,2921,2670,0,0,0]
["2020-06-14",466201.4890375,434.81993999999997,512.07206650000001,96.812114750000006,0,0,0,700596,9437,2256,363,0,0,0]
["2020-07-15",436223.81814749999,642.50567975000001,266.21870849999999,33.794735500000002,0,0,0,598516,34047,5358,1298,0,0,0]
["2020-08-15",450746.06939850003,614.18935950000002,384.92510650000003,45.076812750000002,0,0,0,785958,16288,3611,641,0,0,0]
["2020-09-15",428787.33108275,157.95455525,480.03266150000002,52.070701499999998,0,0,0,1034804,14144,1744,319,0,0,0]
["2020-10-16",408051.60826750001,363.26632525000002,402.76803749999999,73.104245250000005,0,0,0,774835,1847,7234,5171,0,0,0]
["2020-11-16",400873.81396549998,340.40614325000001,850.83036975000005,181.84067099999999,0,0,0,912871,14157,19243,4508,0,0,0]
["Note:"]
["1.  * Notional Turnover"]
["2. ** OI data is at BSE level."]
["$ indicates as on November 30,2020"]
["Source: BSE"]

{"sheet":"46","index":46,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,0,16,14],[17,0,17,8],[18,0,18,8],[0,0,0,6],[1,0,2,0],[1,1,1,7],[1,8,1,14],[14,0,14,8],[15,0,15,8]]}
["Table 46: Instrument-wise Turnover in Currency Derivatives Segment of NSE"]
["Year/Month","Turnover (₹ crore)",null,null,null,null,null,null,"Open Interest as on last day of the month ( in lots)*"]
[null,"USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY","USDINR","EURINR","GBPINR","JPYINR","EURUSD","GBPUSD","USDJPY"]
["2019-20",9009927.9925139993,170324.37954974998,374339.80154675001,75589.004037749997,11480.417642609065,12513.169358854519,219.00372574731111,6680611,81513,32141,30965,650,643,24]
["2020-21$",{"$f":"SUM(B6:B19)","v":6620342.1280999994},{"$f":"SUM(C6:C19)","v":276359.01779000001},439667.40839999996,71843.874733000004,3759.1422950000001,5068.4770386,53.599107080000003,{"$f":"I13","v":6642033},{"$f":"J13","v":239353},194845,40530,4105,1873,42]
["Apr-20",655054.75670000003,11949.74469,23656.508689999999,5267.9496369999997,129.5959632,221.4217347,2.4798537180000002,4875455,67920,42712,36164,1128,1805,47]
["May-20",663982.92599999998,20144.290290000001,37101.386590000002,7695.0969370000003,230.85869769999999,367.38587510000002,5.291468558,4204478,165613,42731,32939,3028,2283,18]
["Jun-20",853857.83900000004,28614.879359999999,55969.384319999997,9383.4079270000002,546.59406430000001,790.48008149999998,7.4848078119999997,4288347,154408,72300,31324,2564,2375,25]
["Jul-20",844302.73690000002,41198.973579999998,47785.242599999998,8475.8479449999995,849.56517020000001,779.05277439999998,4.2529588690000004,4778747,273940,124436,32991,6381,1897,77]
["Aug-20",857995.12269999995,50143.458039999998,56740.37298,10440.619259999999,745.82706559999997,789.41297750000001,9.5164741240000001,4831227,210451,99422,32832,7162,3024,12]
["Sep-20",981988.99509999994,45279.987699999998,79550.149439999994,11919.148370000001,562.6200652,761.34424320000005,11.34469526,5125997,155352,59034,28800,3348,1655,23]
["Oct-20",857549.21869999997,38069.022830000002,72533.403810000003,8522.3834270000007,336.57580780000001,654.92388210000001,2.753618339,5607942,192303,111715,62198,2767,1770,114]
["Nov-20",905610.53300000005,40958.6613,66330.959969999996,10139.42123,357.50546100000003,704.45547009999996,10.475230399999999,6642033,239353,194845,40530,4105,1873,42]
["Notes:"]
["1. Cross Currency was introduced wef Feb 27, 2018"]
["2. Options contracts on EURINR,GBPINR,JPYINR were introduced wef Feb 27, 2018"]
["3. *Open Interest provided in Table No. 42 is at NSE Clearing Limited level, while in Table 46 it is at NSE Level. Hence, the difference in number/value between the two tables."]
["$ indicates as on November 30,2020"]
["Source: NSE."]

{"sheet":"47","index":47,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,8],[17,0,17,8],[0,0,0,6],[1,0,2,0],[1,1,1,4],[1,5,1,8],[14,0,14,8],[15,0,15,8]]}
["Table 47:  Instrument-wise Turnover in Currency Derivatives Segment of MSEI"]
["Year/Month","Turnover (₹ crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2019-20",43153.868839249997,941.32911249999995,1223.80989875,5.5111017499999999,6062,11,0,0]
["2020-21$",{"$f":"SUM(B6:B17)","v":43810.000000250002},{"$f":"SUM(C6:C17)","v":129.34340549999999},{"$f":"SUM(D6:D17)","v":65.895728250000005},{"$f":"SUM(E6:E17)","v":1.0682815000000001},{"$f":"F13","v":38915},{"$f":"G13","v":2396},{"$f":"H13","v":1008},{"$f":"I13","v":60}]
["Apr-20",1782.7734902499999,1.07487325,1.4330572500000001,0,21998,52,25,0]
["May-20",1694.2693977500001,5.6188107499999997,2.5352252499999999,0,9148,506,25,0]
["Jun-20",2830.3128132500001,18.986320249999999,4.9520929999999996,0,15405,201,77,0]
["Jul-20",4050.15318325,11.57521225,2.6938279999999999,0,12489,691,0,0]
["Aug-20",5267.13913925,21.453854249999999,2.7702545000000001,3.5465000000000003E-2,14061,332,52,0]
["Sep-20",6855.9462997500004,19.511039499999999,13.0047035,0.15425475,17122,818,80,8]
["Oct-20",9052.7969822499999,11.5355455,10.840890249999999,2.7848000000000001E-2,12488,9,225,0]
["Nov-20",12276.608694500001,39.58774975,27.6656765,0.85071375000000005,38915,2396,1008,60]
["Notes -"]
["Data includes Notional Value for Options"]
["Excludes data of Interest Rate Futures"]
["$ indicates as on November 30,2020"]
["Source: MSEI"]

{"sheet":"48","index":48,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,5],[2,6,2,10],[16,0,16,8],[17,0,17,8]]}
["Table 48: Maturitywise Turnover in Currency Derivative Segment of BSE"]
[null,null,null,null,null,null,null,null,null,null,"(₹  crore)"]
[null,"Currency Future",null,null,null,null,"Currency Options"]
[null,"Weekly","1 Month","2 Month","3 Month","> 3 months","Weekly","1 Month","2 Month","3 Month","> 3 months"]
["2019-20",67678.573399999994,2427178.9339000001,346918.81520000007,10602.6005,531.97350000000006,455671.57740000007,3139015.6289000004,235548.33520000003,127.55050000000001,0]
["2020-21",124841.5943,962567.28709999984,232449.79240000003,5311.2662,573.92240000000004,538818.53760000016,1055957.3623000002,253566.4516,19.6477,0]
["2020-04-04",7960.0966000000008,99902.342699999994,30270.1973,684.37549999999999,3.2729000000000004,60556.640300000006,43953.919900000001,27813.531299999999,0,0]
["2020-05-04",8918.1,98146.42,24875.23,274.55,8.24,50195.75,89806.55,33912.230000000003,7.81,0]
["2020-06-04",13295.71,129794.97,36969.9,331.2,1.74,49830.09,199656.84,37358.5,6.09,0]
["2020-07-04",19106.900000000001,136887.07,33567.660000000003,815.07,6.06,42237.66,171323.64,33216.53,5.74,0]
["2020-08-04",14000.68,124186.34,29186.13,706.36,31.53,76576.679999999993,183546.54,23556.01,0,0]
["2020-09-04",17283.412800000006,152283.57309999992,20091.901300000005,284.26319999999998,5.3710999999999984,96113.698300000018,103470.18430000002,39944.986800000013,0,0]
["2020-10-04",22833.8593,104438.3431,26737.337300000003,1103.5839000000001,196.40420000000003,93290.604700000011,130976.30700000003,29314.242500000008,7.7000000000000002E-3,0]
["2020-11-04",21442.835599999999,116928.2282,30751.4365,1111.8635999999999,321.30420000000004,70017.414300000004,133223.3811,28450.421000000006,0,0]
["Notes:"]
["1.  Weekly maturity data is added to the table, hence the data may not be strictly comparable with the earlier published data."]
["$ indicates as on November 30,2020"]
["Source: BSE"]

{"sheet":"49","index":49,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,3,0],[2,1,2,4],[2,5,2,9]]}
["Table 49: Maturity-wise Turnover in Currency Derivatives Segment of NSE  "]
[null,null,null,null,null,null,null,null,null,"(₹  crore)"]
["Month/Year","Currency Future",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","Weekly","1 Month","2 Month","3 Month","> 3 months"]
["2020-21$",{"$f":"SUM(B6:B13)","v":2899419.8677946851},{"$f":"SUM(C6:C13)","v":620165.05985952646},52402.095868070603,22197.089902250005,2099843.3956550001,1526082.7505548592,196402.18459462249,562.86577299999999,18.337414749999997]
["2020-04-16",282105.40494778188,81657.161574411686,6045.598669250001,2397.3038892500017,146154.51298624996,159705.52339125,18209.84984875,5.8659007499999998,1.236035]
["2020-05-16",289073.96292616415,71291.097026727366,6200.1757614999997,1243.3119362499997,197766.16782925001,147472.21469299999,16461.794493499998,3.1046317500000002,15.406516]
["2020-06-16",368055.19401860272,79812.84486310283,5741.6815912500006,2615.2436325000003,253763.43202450007,217173.0051121873,21957.789865749997,50.323695000000001,0.55478800000000006]
["2020-07-16",343621.22743649525,75715.724604943796,6821.7067212499996,3196.3859745000009,298499.01717275003,194065.26787208952,21469.900052682919,6.211440249999999,0.23060825000000001]
["2020-08-16",353349.68550738128,82858.698248930639,7197.469908,3790.5285645000004,270486.15418174997,223262.53317144106,35785.982248439577,132.76960975,0.50807124999999997]
["2020-09-16",452948.27855592634,80381.218884495713,6470.9441820000002,3327.9559954999972,351656.5829809999,198197.76313625267,27090.685699999998,0,0.16022424999999998]
["2020-10-16",384692.94180718693,69615.260364926333,7198.7273770000002,2434.3301632500029,299691.94828975009,187425.2971468888,26416.711567249997,193.06537250000002,0]
["2020-11-16",425573.17259514611,78833.05429198801,6725.7916578205995,3192.0297465000008,281825.58018975001,198781.14603175002,29009.47081825,171.52512300000001,0.24117200000000003]
["Note:"]
["1.  Weekly maturity data is added to the table, hence the data may not be strictly comparable with the earlier published data."]
["$ indicates as on November 30,2020"]
["Source: NSE."]

{"sheet":"50","index":50,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,8],[0,0,0,8],[2,0,3,0],[2,1,2,4],[2,5,2,9],[16,0,16,8]]}
["Table 50: Maturity-wise Turnover in Currency Derivatives Segment of MSEI "]
[null,null,null,null,null,null,null,null,null,"(₹  Crore)"]
["Month/Year","Currency Future",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","Weekly","1 Month","2 Month","3 Month","> 3 months"]
["2019-20",39121.486170749995,2373.3683207500003,25.859646249999997,0.35620000000000002,448.08408874999998,3290.3011542499999,65.06337225,0,0]
["2020-21$",{"$f":"SUM(B7:B14)","v":41234.761927750005},2715.65605125,8.4674622499999987,0.25720999999999999,10.865914999999999,33.514843749999997,2.7840249999999997,0,0]
["2020-04-01",1556.7071227500001,227.80689924999999,0.76739875000000002,0,0,0,0,0,0]
["2020-05-31",1483.9977267500001,211.95682475000001,6.4688822500000001,0,0,0,0,0,0]
["2020-06-01",2632.5162937499999,220.59277650000001,1.14215625,0,0,0,0,0,0]
["2020-07-01",3514.5665024999998,527.65367975000004,0,0,0,22.202041250000001,0,0,0]
["2020-08-01",5026.9830835000002,264.28710949999999,0,0.12852,0,0,0,0,0]
["2020-09-01",6583.3953950000005,301.36740799999995,1.489E-2,0.12869,0,2.9655750000000003,0.74435000000000007,0,0]
["2020-10-01",8861.4026020000001,206.14597799999999,7.4135000000000006E-2,0,6.8384099999999997,0.74014999999999997,0,0,0]
["2020-11-01",11575.193201500009,755.84537549999993,0,0,4.0275049999999997,7.607077499999999,2.0396749999999999,0,0]
["Note:"]
["1.  Weekly maturity data is added to the table, hence the data may not be strictly comparable with the earlier published data."]
["$ indicates as on November 30,2020"]
["Source: MSEI"]

{"sheet":"51","index":51,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,3,0],[1,1,3,1],[1,2,1,5],[1,6,1,11],[1,12,1,15],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[19,0,19,15],[20,0,20,15],[2,10,2,11],[2,12,2,13],[2,14,2,15],[15,0,15,15],[16,0,16,15],[17,0,17,15],[18,0,18,15]]}
["Table 51: Trading Statistics in Interest Rate Derivatives Segment"]
["Year/ Month","No. of Trading Days","BSE*",null,null,null,"NSE",null,null,null,null,null,"MSEI"]
[null,null,"Interest Rate Futures",null,"Open Interest at\nthe end of",null,"Interest Rate Futures",null,"Interest Rate Option",null,"Open Interest at\nthe end of**",null,"Interest RateFutures",null,"Open Interest at the end of "]
[null,null,"No. of Contracts","Traded Value \n(₹ crore)","No. of Contracts","Value \n(₹ crore)","No. of\nContracts","Traded Value \n(₹ crore)","No. of\nContracts","Traded Value \n(₹ crore)","No. of\nContracts","Value \n(₹ crore)","No. of Contracts ","Traded Value \n(₹ crore)","No. of Contracts","Value \n(₹ crore)"]
["2019-20",243,4917740,100045.43150000001,32362,682.81,17217124,351817.75828999997,444761,8993.3808099999987,77036,1592.8485949999999,0,0,0,0]
["2020-21$",{"$f":"SUM(B7:B16)","v":163},{"$f":"SUM(C7:C16)","v":962675},{"$f":"SUM(D7:D16)","v":19875.492500000004},{"$f":"E14","v":3595},{"$f":"F14","v":76.399231819999997},{"$f":"SUM(G7:G16)","v":3703289},{"$f":"SUM(H7:H16)","v":75853.855242000005},{"$f":"SUM(I7:I16)","v":41368},{"$f":"SUM(J7:J16)","v":854.3618295},{"$f":"K14","v":57654},{"$f":"L14","v":1185.809375},{"$f":"SUM(M7:M16)","v":0},{"$f":"SUM(N7:N16)","v":0},{"$f":"O14","v":0},{"$f":"P14","v":0}]
["Apr-20",17,117135,2394.6293999999998,22389,486.62,462985,9422.5825435000006,15183,311.16420499999998,51482,1075.917142,0,0,0,0]
["May-20",18,92350,1898.7684999999999,32071,695.75,578495,11886.515042499999,15039,311.33295500000003,66972,1409.258315,0,0,0,0]
["Jun-20",22,207052,4307.7403000000004,25260,525.02,803319,16565.8619755,10776,224.1784285,102803,2140.6479290000002,0,0,0,0]
["Jul-20",23,193802,4082.3089,19100,399.24,554091,11472.240318,266,5.5394410000000001,59617,1260.5093810000001,0,0,0,0]
["Aug-20",21,65635,1339.4258,5447,112.12,434184,8835.9610809999995,3,6.1254500000000003E-2,65722,1365.007214,0,0,0,0]
["Sep-20",22,30352,618.83699999999999,1750,37.548735000000001,389067,7966.1150095000003,101,2.0855454999999998,45801,953.33148700000004,0,0,0,0]
["Oct-20",20,94839,1949.4366,1252,27.858011319999999,294052,5969.361613,0,0,58345,1205.0731149999999,0,0,0,0]
["Nov-20",20,161510,3284.346,3595,76.399231819999997,187096,3735.2176589999999,0,0,57654,1185.809375,0,0,0,0]
["Notes:"]
["1. IR Options were launched at NSE during Dec 2019, the data has been revised accordingly"]
["2. Open interest is valued at daily settlement prices"]
["3. The Open interest pertains to NSE Clearing and Includes the data of multiple exchnages)"]
["4. IR Options were launched at BSE during Aug 2019.  However, there is no trading activity since launch."]
["$ indicates as on November 30,2020"]
["Source: BSE, NSE and MSEI"]

{"sheet":"52","index":52,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,4,0],[2,1,2,2],[2,3,2,6],[2,7,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
["Table 52: Settlement Statistics in Interest Rate Derivatives Segment "]
[null,null,null,null,null,null,null,null,"(₹  crore)"]
["Year/ Month","BSE",null,"NSE",null,null,null,"MSEI"]
[null,"Interest Rate Futures",null,"Interest Rate futures",null,"Interest Rate options",null,"Interest Rate Futures"]
[null,"MTM\nSettlement","Final Settlement","MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement","MTM Settlement","Final Settlement"]
["2019-20",1417.0222240000001,23.052129999999998,1400.2491004000001,20.05797746,16.880000000000003,2.5465377399999998,0,0]
["2020-21$",{"$f":"SUM(B8:B21)","v":295.40395900000004},2.6258560000000002,335.78793551999996,3.0427754399999998,2.83,2.3698597600000002,0,0]
["Apr-20",100.356579,0.31318800000000002,78.215149999999994,0.38330287999999996,1.1000000000000001,1.8539694799999999,0,0]
["May-20",50.891993999999997,4.7840000000000001E-2,51.993362500000003,0.26414280000000001,1.1399999999999999,0.50847503999999999,0,0]
["Jun-20",40.929543000000002,0.73642099999999999,48.623053499999997,0.33827309999999999,0.56000000000000005,0,0,0]
["Jul-20",25.355761000000001,3.3484E-2,42.119494000000003,0.17433314000000003,0.02,7.3915999999999999E-3,0,0]
["Aug-20",25.204654999999999,1.0989629999999999,38.964887019999999,0.59955239999999987,0,0,0,0]
["Sep-20",23.771080000000001,8.4750000000000006E-2,31.664533500000001,9.5656600000000008E-2,0.01,2.3640000000000001E-5,0,0]
["Oct-20",16.550516999999999,0.2172,22.685473500000001,0.61006404000000003,0,0,0,0]
["Nov-20",12.343830000000001,9.4009999999999996E-2,21.521981499999999,0.57745047999999999,0,0,0,0]
["Note:"]
["1.  NSE - IRF includes 6 Year, 10 Year, 13 Year GSecs and 91 DTB"]
["2. IR Options were launched at NSE during Dec 2019, the data has been revised accordingly"]
["3. IR Options were launched at BSE during Aug 2019.  However, there is no trading activity since launch."]
["$ indicates as on November 30, 2020"]
["Source: ICCL, NCL and MCCIL"]

{"sheet":"53","index":53,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3],[13,0,13,5],[14,0,14,5]]}
["Table 53: Trends in Foreign Portfolio Investment"]
["Year/Month","Gross Purchase \n(₹  crore)","Gross Sales \n(₹  crore)","Net Investment \n(₹  crore)","Net Investment \n(USD million)","Cumulative Net Investment \n(USD million)"]
["2019-20",1905516.99,1933046.1599999997,-27529.170000000013,-3041.5499999999993,245112.63]
["2020-21$",{"$f":"SUM(B5:B15)","v":1368815.48},{"$f":"SUM(C5:C15)","v":1232827.5299999998},{"$f":"SUM(D5:D15)","v":135987.95000000001},{"$f":"SUM(E5:E15)","v":18303.77},{"$f":"F12","v":263416.40000000002}]
["Apr-20",144753.65,159612.19,-14858.54,-1961.18,{"$f":"F3+E5","v":243151.45}]
["May-20",150169.19,157525.04,-7355.85,-972.51,{"$f":"F5+E6","v":242178.94}]
["Jun-20",202141.05,176131.62,26009.43,3440.94,{"$f":"F6+E7","v":245619.88}]
["Jul-20",151569.69,148268.25,3301.44,450.99,246070.87]
["Aug-20",177960.26,128081.31,49878.95,6661.85,252732.72]
["Sep-20",168469.44,169665.82,-1196.3800000000001,-156.61000000000001,252576.11000000002]
["Oct-20",157460.03,135633.9,21826.13,2974.36,255550.47]
["Nov-20",216292.17,157909.4,58382.77,7865.93,263416.40000000002]
["Notes:"]
["$ indicates up to November 30,2020"]
["Source: NSDL, CDSL"]

{"sheet":"54","index":54,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,5]]}
["Table 54: Notional Value of Offshore Derivative Instruments (ODIs) compared to Assets Under Custody (AUC) of FPIs/Deemed FPIs"]
["Year/ Month","Notional value of ODIs on Equity, Debt & Derivatives  (₹ crore)","Notional value of ODIs on Equity & Debt  excluding Derivatives  (₹ crore)","Assets Under Custody of FPIs/Deemed FPIs  (₹ crore) #","Notional value of ODIs on Equity, Debt & Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs","Notional value of ODIs on Equity & Debt  excluding Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs"]
["2019-20",48006.398270333913,47852,2490223,{"$f":"(B3/D3)*100","v":1.9277951520941663},{"$f":"(C3/D3)*100","v":1.9215949736228441}]
["2012-21$",{"$f":"B12","v":83114},{"$f":"C12","v":83114},{"$f":"D12","v":3850843},{"$f":"(B4/D4)*100","v":2.1583326040557873},2.1583326040557873]
["Apr-20",57100,56923,2819841,2.0249368670077499,2.0186599173499498]
["May-20",60027,59869,2743734,2.1877849674932044,2.1820263917712137]
["Jun-20",62137.931794577897,61974.282086353691,2979826,2.0852872548456824,2.0797953332293124]
["Jul-20",63228,63035,3167785,1.9959687920739571,1.9898762068764138]
["Aug-20",74027.297051521688,73826,3317805,2.2312130173871485,2.2251458419045123]
["Sep-20",69820.572747645827,69820.572747645827,3322393,2.1015145633778372,2.1015145633778372]
["Oct-20",78686.403269105824,78686.403269105824,3436258,2.2898863609515296,2.2898863609515296]
["Nov-20",83114,83114,3850843,2.1583326040557873,2.1583326040557873]
["Notes:"]
["1. Column B & C  Figures are compiled based on reports submitted by FPIs/deemed FPIs issuing ODIs."]
["2. Column C is being provided which depicts the Total Value of ODI issued -with underlying as  Equity ,Debt & Hybrid Securities but excluding derivatives"]
["3. Column D  Figures are compiled on the basis of reports submitted by custodians & does not includes positions taken by FPIs/deemed FPIs in derivatives."]
["4. The total value of ODIs excludes the unhedged positions & portfolio hedging positions taken by the FPIs/deemed FPIs issuing ODIs."]
["$ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"55","index":55,"n_rows":18,"n_cols":29,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,27,1,28],[0,0,0,25],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,23,1,24],[1,25,1,26],[13,0,13,25],[14,0,14,25],[15,0,15,25],[16,0,16,25],[17,0,17,25]]}
["Table 55: Assets under the Custody of Custodians"]
["Type of Client","FPIs ",null,"Foreign\nDepositories",null,"FDI\nInvestments",null,"Foreign\nVenture\nCapital\nInvestments",null,"OCBs",null,"NRIs",null,"Mutual\nFunds",null,"Corporates",null,"Banks",null,"Insurance\nCompanies",null,"Local\nPension\nFunds",null,"Financial\nInstitutions",null,"Others",null,"Total"]
[null,"No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)","No.","Amount \n(₹   crore)"]
["2019-20",9825,2490223.13,66,227791.97,2079,832863.69,208,38124.839999999997,25,1582.04,693,2098.92,1624,1891137.87,598,88517.75,121,412044.02,788,1547943.43,124,477968.29,25,40702.49,25595,967716.71,41771,9018715.1500000004]
["2020-21$",{"$f":"B13","v":10017},{"$f":"C13","v":3850842.89},66,431561.42,2253,1194938.6100000001,214,40479.72,24,2166.94,794,2928.46,1630,2295811.2799999998,639,104591.18,123,532753.11,792,1959835.58,113,552864.79,26,40181.519999999997,28643,1151076.6599999999,45334,12160032.16]
["Apr-20",9916,2819840.63,66,264852.96000000002,2088,891652.54,208,38313.550000000003,25,1678.47,693,2287.0300000000002,1621,2031625.42,600,92221.83,121,484474.78,790,1656179.49,124,486918.55,26,42889.59,25629,1000395.04,41907,9813329.8800000008]
["May-20",9912,2743734.07,66,251650.89,2098,869794.25,210,38512.69,25,1564.8,698,2438.62,1622,2001267.16,600,96705.97,121,496496.67,790,1650619.6,112,493260.74,26,44232.99,25655,986317.56,41935,9676596.0099999998]
["Jun-20",9911,2979825.58,66,310240.28999999998,2106,927607.89,211,38925.86,25,1721.14,703,2639.04,1625,2032087.29,598,98195.29,124,494660.29,793,1731728.51,112,503181.73,26,44802.16,25829,1016537.42,42129,10182152.49]
["Jul-20",10059,3167785.41,66,342150.79,2145,981263.97,212,39105.11,25,1769.78,740,2753.77,1630,2101536.2799999998,615,99802.42,124,509473.4,793,1790710.93,119,513076.47999999998,26,45490,26655,1040909.16,43209,10635827.5]
["Aug-20",10071,3317805.32,66,361713.46,2155,1016525.73,212,39604.959999999999,25,1760.36,746,2879.08,1636,2158248.83,624,101890.3,123,520463.14,792,1834368.24,119,524306.98,26,46103.4,27256,1065804.43,43851,10991474.23]
["Sep-20",9972,3322393,66,368260.05,2177,1050353.81,212,40359.68,25,1604.49,765,2742.21,1630,2098922.56,635,102139.5,124,513385.09,794,1823503.44,115,533973.80000000005,26,42735.5,27814,1062131.21,44355,10962504.34]
["Oct-20",9984,3436257.51,66,382987.29,2229,1082379.3799999999,211,40576.449999999997,25,1828.28,785,2732.66,1632,2166199.39,640,103530,123,527990.69999999995,793,1854228.43,115,544212.66,26,36541.14,28257,1091199.3,44886,11270663.189999999]
["Nov-20",10017,3850842.89,66,431561.42,2253,1194938.6100000001,214,40479.72,24,2166.94,794,2928.46,1630,2295811.2799999998,639,104591.18,123,532753.11,792,1959835.58,113,552864.79,26,40181.519999999997,28643,1151076.6599999999,45334,12160032.16]
["Notes: "]
["1. With the commencement of FPI Regime from June 1, 2014, the erstwhile FIIs, Sub Accounts and QFIs are merged into a new investor class termed as .Foreign Portfolio Investors (FPIs)."]
["2. \"Others\" include Portfolio manager, partnership firm, trusts, depository receipts, AIFs, FCCB, HUFs, Brokers etc."]
["$ indicates as on November 30,2020"]
["Source: Custodians."]

{"sheet":"56","index":56,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,7,2,9],[2,10,3,10],[15,0,15,4],[16,0,16,4],[0,0,0,4],[2,0,3,0],[2,1,2,3],[2,4,2,6]]}
["Table 56: Trends in Resource Mobilization by Mutual Funds "]
[null,null,null,null,null,null,null,null,null,null," (₹   crore)"]
["Year / Month","Gross Mobilisation",null,null,"Redemption",null,null,"Net Inflow/ Outflow",null,null,"Assets at the\nEnd of\nPeriod"]
[null,"Pvt. Sector","Public Sector","Total","Pvt. Sector","Public Sector","Total","Pvt. Sector","Public Sector","Total"]
["2019-20",14989990.49,3823467.281,18813457.77,14965931.060000001,3760225.8909999998,18726156.949999999,24059.435409999998,63241.390570000003,87300.825979999994,2226202.8650000002]
["2020-21$",{"$f":"SUM(B7:B17)","v":4716876.0460000001},1073955.0930000001,5790831.1389999995,4504090.4929999998,1013723.341,5517813.8339999998,212785.56219999999,60231.752459999989,273017.31459999998,{"$f":"K14","v":3000904.44}]
["Apr-20",614258.18709999998,206442.2309,820700.4179,593456.62309999997,181244.3076,774700.93070000003,20801.56393,25197.923299999999,45999.487229999999,2393485.5430000001]
["May-20",619156.47290000005,246977.14910000001,866133.62210000004,562437.9669,232882.14240000001,795320.10930000001,56718.506070000003,14095.0067,70813.512770000001,2454757.5299999998]
["Jun-20",711244.24100000004,249561.2634,960805.505,701503.31,252036.22399999999,953539.53399999999,9740.9320599999992,-2474.96056,7265.9714999999997,2548848.4339999999]
["Jul-20",518550.88099999999,192070.14939999999,710621.02899999998,462909.77,157898.97150000001,620808.74100000004,55641.10914,34171.177799999998,89812.286999999997,2711894.15]
["Aug-20",404939.098,151656.2072,556595.30599999998,414119.41,157028.75450000001,571148.16500000004,-9180.3112000000001,-5372.5372399999997,-14552.8485,2749388.53]
["Sep-20",496584.97100000002,169773.86259999999,666358.83299999998,534398.20700000005,184051.8357,718450.04299999995,-37813.235030000003,-14277.983109999999,-52091.218099999998,2685981.915]
["Oct-20",470512.67200000002,172724.8222,643237.495,391937.76199999999,152723.73319999999,544661.495,78574.908630000005,20001.089029999999,98575.997600000002,2822940.8739999998]
["Nov-20",881629.52300000004,-315250.59179999999,566378.93099999998,843327.44400000002,-304142.62790000002,539184.81599999999,38302.088600000003,-11107.963460000001,27194.125100000001,3000904.44]
["Note:"]
["$ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"57","index":57,"n_rows":93,"n_cols":14,"rows_kept":93,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[1,2,1,7],[1,8,1,13],[92,0,92,1]]}
["Table 57:  Status of Mutual Funds Industry in India "]
["Sr. No.","Scheme Category","2019-20",null,null,null,null,null,"2020-21$"]
[null,null,"No. of schemes ","No. of Folios ","Funds mobilized  (₹ crore)","Repurchase/ Redemptio  (₹ crore)","Net Inflow (+ve)/ Outflow (-ve)   (₹ crore)","Net Assets Under Management as on  (₹ crore)","No. of schemes ","No. of Folios ","Funds mobilized  (₹ crore)","Repurchase/ Redemptio  (₹ crore)","Net Inflow (+ve)/ Outflow (-ve)   (₹ crore)","Net Assets Under Management as on  (₹ crore)"]
["A","Open ended Schemes"]
["I","Income/Debt Oriented Schemes"]
[1,"Overnight Fund",30,86255,3104154.0667759995,3036499.7779539716,67654.28882202816,80174.192291984597,30,116364,2104639.351766062,2128913.0183894583,-24273.66662339681,57514.599460879777]
[2,"Liquid Fund",39,1815547,14430056.329323001,14505186.054505004,-75129.725182001814,334725.3213015318,38,2164701,2519811.6501603024,2489861.9827092113,29949.667451091518,375646.62519736745]
[3,"Ultra Short Duration Fund",29,650202,185685.09487737255,195237.94583798823,-9552.8509606156586,72226.364568975245,29,733257,126788.71105693809,98375.845187188708,28412.865869739384,104930.96167470604]
[4,"Low Duration Fund",26,963640,127452.33041418077,136233.17545214473,-8780.8450379639798,81371.187137965753,26,1134891,189117.04898724688,125051.83844084996,64065.210546396913,150945.4384146762]
[5,"Money Market Fund",20,350429,193476.63954390472,193561.71436373022,-85.074819825480972,57016.643850834022,20,458938,173602.95663908633,134561.86932953299,39041.087309553332,99003.216372340772]
[6,"Short Duration Fund",28,359856,60309.593780412593,51733.484357941859,8576.1094224707285,93444.339442586293,26,612061,114421.63666672421,62556.044505026432,51865.58216169777,153019.41897407925]
[7,"Medium Duration Fund",18,221149,7325.8834682326251,17778.474863760603,-10452.591395527979,28290.289846830285,19,291821,9610.9267569963868,11708.322115342999,-2097.3953583466109,27375.564961589422]
[8,"Medium to Long Duration Fund",14,108506,2086.6459060477173,3147.5747499203171,-1060.9288438725998,9804.7908106611922,14,121753,4094.7315887344212,2706.8974261685112,1387.8341625659095,11980.947770668452]
[9,"Long Duration Fund",2,27215,628.5458478581354,278.32056125400004,350.22528660413542,1669.5749464186913,2,30569,1235.4754370796848,536.38894798500007,699.08648909468468,2516.950052925421]
[10,"Dynamic Bond Fund",29,215543,5571.706000654719,8309.8008656759994,-2738.0948650212804,18115.974121491414,27,286866,11946.232899211283,6232.4033796532003,5713.8295195580822,25061.807724748611]
[11,"Corporate Bond Fund",20,391721,49845.542744406193,31577.580181540001,18267.962562866192,81729.798821482749,20,639905,96923.389486868793,37458.687753771002,59464.701733097783,149604.30977765593]
[12,"Credit Risk Fund",23,461927,9276.4142857952484,37303.949861584064,-28027.535575788814,55380.524188531796,22,372020,1902.0537271095588,30001.446812477996,-28099.403085368438,28545.083098017854]
[13,"Banking and PSU Fund",19,170392,59782.85583444596,25271.312635743183,34511.54319870277,72475.856660864214,21,358114,96709.361561439888,52928.79712998325,43780.574431456662,123449.37370261797]
[14,"Gilt Fund",21,116938,5879.9775928194576,5170.9811173282751,708.99647549118345,9284.9759829144186,21,217987,19583.623954286733,9544.2822893625853,10039.341664924146,20301.890263577294]
[15,"Gilt Fund with 10 year constant duration",4,34206,789.05916811300006,446.77712390199997,342.28204421099997,941.41219401438013,4,57593,937.30764728676058,443.16831732499998,494.1393299617605,1525.1642762224758]
[16,"Floater Fund",7,162058,36316.737786070204,35678.485120826008,638.25266524420385,32490.431134149123,8,204728,47687.303549977798,27199.594572094,20487.708977883802,55707.615702239054]
[null,"Sub total - I (1+2+3+4+5+6+7+8+9+10+11+12+13+14+15+16)",329,6135584,18278637.423349313,18283415.40955231,-4777.9862029992328,1029141.6773012358,327,7801568,5519011.7618853524,5218080.5873054331,300931.16457990994,1387128.9674243121]
[]
["II","Growth/Equity Oriented Schemes"]
[17,"Multi Cap Fund",34,9264215,45594.025753337883,30033.961169581464,15560.064583756426,113908.48534887873,35,9495460,20950.791831604722,27808.763870543622,-6857.9620389288966,160052.72782966413]
[18,"Large Cap Fund",29,10028315,49942.58972327716,33939.253940046889,16003.335783230275,113541.25340863605,31,10316712,24380.649616136347,27681.110230101884,-3300.4606139655366,163104.47126263092]
[19,"Large & Mid Cap Fund",27,4735650,17834.196607885489,12541.878803005366,5292.3178048801228,42971.995422114334,28,4834111,10630.377211010402,9862.8051741373347,767.57203687306674,66391.803470477098]
[20,"Mid Cap Fund",27,6498964,30246.469627091439,16729.014988343733,13517.454638747702,65804.848930772045,26,6441713,12727.494841615271,15036.325601369565,-2308.8307597542962,100696.95121527753]
[21,"Small Cap Fund",23,5128434,21544.745674487225,11113.774490803877,10430.97118368335,35832.031286181911,23,4959637,8915.367226948496,9566.423118867333,-651.05589191883462,59209.501635419794]
[22,"Dividend Yield Fund",6,470525,365.86219874400001,743.54862671499995,-377.686427971,3282.0084482292932,6,448580,165.13823416728297,404.18625370699999,-239.04801953971702,4409.6719371335903]
[23,"Value Fund/Contra Fund",17,4131763,12840.084762151177,14770.547673972873,-1930.4629118216969,39459.523672551848,17,3886059,5189.9560599731667,9434.1565739274629,-4244.2005139542944,56573.119927190688]
[24,"Focused Fund",22,3570651,23485.73361535052,10650.821706157074,12834.911909193448,39071.922440695627,25,3753444,11693.740882808113,9407.4589990436234,2286.2818837644909,60524.703695110395]
[25,"Sectoral/Thematic Funds",96,6528979,20900.560135889402,16631.597691730614,4268.9624441587839,49844.160506678665,98,7029274,15757.816720909008,13598.883992929026,2158.9327279799854,75594.148689976166]
[26,"ELSS",43,12335172,17429.36016490576,9242.2797320221853,8187.0804328835711,74791.498748658283,42,12385407,8176.6401449092409,6934.5681310154341,1242.0820138938084,110953.34079418014]
[null,"Sub total - II (17+18+19+20+21+22+23+24+25+26)",324,62692668,240183.62826312004,156396.67882237906,83786.94944074098,578507.72821339685,331,63550397,118587.97277008204,129734.68194564228,-11146.689175550222,857510.44045706047]
[]
["III","Hybrid Schemes"]
[27,"Conservative Hybrid Fund",22,386103,1165.5897263883048,4894.8240683645736,-3729.2343419762683,11189.68047502978,22,377917,1727.3729513117096,2670.7905398583471,-943.4175885466376,11826.379779399886]
[28,"Balanced Hybrid Fund/Aggressive Hybrid Fund",33,5272614,27229.243232883091,48781.129242591043,-21551.886009707967,100990.17902722374,33,4918476,7984.8510517089398,24197.656943500555,-16212.805891791613,118310.28742915584]
[29,"Dynamic Asset Allocation/Balanced Advantage",23,2657247,29572.946994399783,23497.174200168731,6075.7727942310557,77091.389533361667,23,2674916,11275.477148283609,15685.789164715663,-4410.3120164320544,94088.572700591336]
[30,"Multi Asset Allocation",8,631330,4243.5340999724831,3490.0690572085082,753.46504276397502,9439.4050171137987,10,721631,2564.9254047781524,2271.3967958691633,293.52860890898938,13533.379063389748]
[31,"Arbitrage Fund",25,296071,86320.86078416559,84637.864433798328,1682.9963503672657,52210.302000569289,27,397903,49915.584757893885,35593.606539438137,14321.978218455735,62781.389284159552]
[32,"Equity Savings Fund",23,329350,2447.9156112412593,9445.474456471793,-6997.558845230531,11228.912211943523,23,298466,759.53692299892953,3866.6739642821594,-3107.1370412832293,10032.174605387574]
[null,"Sub total - III (27+28+29+30+31+32)",134,9572715,150980.09044905051,174746.535458603,-23766.44500955247,262149.86826524179,138,9389309,74227.748236975225,84285.913947664027,-10058.165710688811,310572.18286208395]
[]
["IV","Solution Oriented  Schemes"]
[33,"Retirement Fund",24,2544753,3155.4759845799999,1113.0925893046999,2042.3833952753,8507.0652043591217,24,2546069,1173.8533636577099,923.82411776899994,250.02924588871019,11407.895601477197]
[34,"Childrens' Fund",9,2892087,851.94797451082786,440.18600094256954,411.76197356825855,7192.1791421455637,10,2890935,473.33935258073927,220.27213873013559,253.06721385060357,9866.1207696482652]
[null,"Sub total - IV (33+34)",33,5436840,4007.4239590908278,1553.2785902472694,2454.1453688435586,15699.244346504685,34,5437004,1647.1927162384491,1144.0962564991355,503.09645973931379,21274.016371125465]
[]
["V","Other Schemes"]
[35,"Index Funds",32,544075,8221.7278099505056,3205.0868115734311,5016.6409983770745,8088.996682432592,37,775616,6388.3654822605686,4785.8607894353172,1602.5046928252514,14301.143066673591]
[36,"GOLD ETFs",11,526671,2514.7871980499999,901.19522454427681,1613.5919735057232,7949.0628744751848,11,838149,5871.1285535129991,1161.521866006347,4709.6066875066517,13239.882536240753]
[37,"Other ETFs",76,1899781,123007.73807137753,63198.326308484517,59809.411762893018,146462.67481179998,88,3248481,60521.205784940001,39247.701648447415,21273.504136492578,233668.69866244469]
[38,"Fund of funds investing overseas",28,189784,1392.9029335969999,522.36335582007507,870.53957777692483,2734.3551154855036,29,464020,4495.7129577908927,1123.3422064594854,3372.3707513314071,7641.9736444900664]
[null,"Sub total - V (35+36+37+38)",147,3160311,135137.15601297506,67826.971700422306,67310.184312552752,165235.08948419325,165,5326266,77276.412778504469,46318.426510348567,30957.986268155888,268851.69790984911]
[]
[null,"Total A-Open ended Schemes",967,86998118,18808945.722033549,18683938.874123961,125006.84790958559,2050733.6076105726,995,91504544,5790751.0883871522,5479563.7059655879,311187.39242156607,2845337.3050244311]
[]
["B","Close  Ended Schemes"]
["I","Income/Debt Oriented Schemes"]
["i","Fixed Term Plan",742,851658,4013.9855413139999,32726.769196192003,-28712.783654878,140594.52457520913,582,521582,76.441790505,30110.071625289002,-30033.629834784002,118458.76732897265]
["ii","Capital Protection Oriented  Schemes",31,107535,489.01860140000002,2665.4728133068024,-2176.4542119068024,4209.97686122907,22,59827,0,1867.8374759739984,-1867.8374759739984,2628.9484782838226]
["iii","Infrastructure Debt Fund ",9,89,0,314.72242813100002,-314.72242813100002,2391.3706024945245,9,89,0,0,0,2328.0148990755179]
["iv","Other Debt",33,83390,0,2605.9309370270003,-2605.9309370270003,3426.8873431012225,9,18947,0,2875.9384673089999,-2875.9384673089999,779.42698995617184]
[null,"Sub total (i+ii+iii+iv)",815,1042672,4503.0041427139995,38312.8953746568,-33809.891231942805,150622.75938203395,622,600445,76.441790505,34853.847568572004,-34777.405778067005,124195.15769628817]
[]
["II","Growth/Equity Oriented Schemes"]
["i","ELSS",25,470566,0,322.09820754499998,-322.09820754499998,3044.9470239677185,25,457228,0,150.49338709799997,-150.49338709799997,4438.9202652888198]
["ii","Others",86,1230807,3.999999999999837E-5,1868.3248542700007,-1868.3248142700006,21408.902390166691,73,1113484,-1.0000000000000001E-5,3202.034424406997,-3202.0344344069968,26547.91566307647]
[null,"Sub total (i+ii)",111,1701373,3.999999999999837E-5,2190.4230618150009,-2190.4230218150005,24453.849414134409,98,1570712,-1.0000000000000001E-5,3352.5278115049969,-3352.5278215049966,30986.83592836529]
[]
["III","Other Schemes",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total B -Close ended Schemes",926,2744045,4503.0041827139994,40503.318436471804,-36000.31425375781,175076.60879616835,720,2171157,76.441780504999997,38206.375380076999,-38129.933599572003,155181.99362465346]
[]
["C","Interval Schemes"]
["I","Income/Debt Oriented Schemes",23,3888,9.0477382380000044,1714.7554145029999,-1705.7076762649999,392.64872913278566,23,3632,3.6088692999999994,43.753058168999999,-40.144188869000004,385.14119107230573]
[]
["II","Growth/Equity Oriented Schemes",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["III","Other Schemes",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total C -Interval Schemes",23,3888,9.0477382380000044,1714.7554145029999,-1705.7076762649999,392.64872913278566,23,3632,3.6088692999999994,43.753058168999999,-40.144188869000004,385.14119107230573]
[]
["Grand Total (A+B+C)","Grand Total (A+B+C)",1916,89746051,18813457.7739545,18726156.947974935,87300.825979562796,2226202.8651358737,1738,93679333,5790831.1390369572,5517813.8344038343,273017.31463312509,3000904.4398401571]
[]
[null,"Fund of Funds Scheme (Domestic)",46,637072,10813.35154536839,1930.1320254151196,8883.2195199532707,12257.11304643228,50,1015460,10253.75870095147,3697.6033852713581,6556.1553156801101,21934.622362225724]
["Notes:"]
["1. No.of schemes also includes serial plans."]
["2. Inter scheme investments are excluded from the above data"]
["$ indicates as on November 30, 2020"]
["Source: SEBI."]

{"sheet":"58","index":58,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,6],[0,0,0,8],[2,0,3,0],[2,1,2,3],[2,4,2,6],[2,7,2,9],[15,0,15,6]]}
["Table 58: Trends in Transactions on Stock Exchanges by Mutual Funds"]
[null,null,null,null,null,null,null,null,null," (₹ crore)"]
["Year/  Month","Equity",null,null,"Debt",null,null,"Total"]
[null,"Gross Purchases","Gross Sales","Net Purchases /Sales","Gross Purchases","Gross Sales","Net Purchases /Sales","Gross Purchases","Gross Sales","Net purchases /Sale"]
["2019-20",807672.21,715713.18000000017,91959.03,2263634.98,1846883.0300000003,416751.95,3071307.19,2562596.2100000004,508710.97999999952]
["2020-21$",{"$f":"SUM(B7:B17)","v":477931.48},547670.74,-69739.260000000009,1158890.2799999998,989613.17999999993,169277.1,1636821.7599999998,1537283.92,99537.839999999967]
["Apr-20",54525.1,62490.6,-7965.5,121444.56,131239.1,-9794.5400000000009,175969.66,193729.7,-17760.040000000008]
["May-20",70794.759999999995,64272.31,6522.45,139959.84,129260.47,10699.37,210754.59999999998,193532.78,17221.819999999978]
["Jun-20",73265.58,73767.08,-501.5,179002.03,137637.32,41364.71,252267.61,211404.40000000002,40863.209999999963]
["Jul-20",61103.69,70298.73,-9195.0400000000009,171073.17,139175.32,31897.85,232176.86000000002,209474.05,22702.810000000027]
["Aug-20",56271.3,65484.74,-9213.44,142115.71,116335.43,25780.28,198387.01,181820.16999999998,16566.840000000026]
["Sep-20",63901.29,68035.66,-4134.37,151055.35999999999,134050.39000000001,17004.97,214956.65,202086.05000000002,12870.599999999977]
["Oct-20",48961.53,63453.32,-14491.79,144610.72,112635.61,31975.11,193572.25,176088.93,17483.320000000007]
["Nov-20",49108.23,79868.3,-30760.07,109628.89,89279.54,20349.349999999999,158737.12,169147.84,-10410.720000000001]
["Note:"]
["$ indicates up to November 30,2020"]
["Source: SEBI"]

{"sheet":"59","index":59,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,0,4,8],[1,1,1,4],[1,5,1,8]]}
["Table 59: Assets Managed by Portfolio Managers"]
["Year / Month","2019-20",null,null,null,"2020-21$"]
["Particulars","Discretionary","Non-Discretionary","Advisory","Total","Discretionary#","Non-Discretionary","Advisory**","Total"]
["No. of Clients",138829,6853,4038,149720,145404,8409,1983,{"$f":"F4+G4+H4","v":155796}]
["AUM (₹ crore)"]
["Listed Equity",111995.61,18477.080000000002,0,130472.69,130527.0191,20992.521000000001,0,{"$f":"SUM(F6:H6)","v":151519.54010000001}]
["Unlisted Equity",458.85,74.69,0,533.54,398.43599999999998,143.48400000000001,0,{"$f":"SUM(F7:H7)","v":541.91999999999996}]
["Plain Debt",1160856.72,74701.850000000006,0,1235558.57,1469555.22,83816.851999999999,0,1553372.0719999999]
["Structured Debt",752.86,530.57000000000005,0,1283.43,1975.087,1404.7829999999999,0,3379.87]
["Equity Derivatives",466.12,-1.24,0,464.88,547.43399999999997,7.0000000000000001E-3,0,547.44099999999992]
["Mutual Funds",14112.76,13856.15,0,27968.91,14948.273999999999,12145.105,0,27093.379000000001]
["Others",14498.29,1392.08,0,15890.37,7527.558,2476.41,0,10003.968000000001]
["Total*",1303141.21,109031.18,193620,1605792.39,1625479.0280999998,120979.162,175452.641,{"$f":"SUM(F13:H13)","v":1921910.8310999998}]
["Notes:"]
["1. **Value of Assets for which Advisory Services are being given. "]
["2. #of the above AUM Rs. 14,61,772.645/- Crores are contributed by funds from EPFO/PFs."]
["3.  The above data is based on the monthly report received from Portfolio Managers."]
["$ indicates up to November 30, 2020"]
["Source: SEBI."]

{"sheet":"60","index":60,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,11],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[17,0,17,11],[23,0,23,6]]}
["Table 60: Progress Report of NSDL & CDSL as on end of November 2020 (Listed Companies)"]
["Parameter","Unit","NSDL",null,null,null,null,"CDSL"]
[null,null,"Nov-20","Oct-20","Nov-19","% Change during the year","% Change during the month","Nov-20","Oct-20","Nov-19","% Change during the year","% Change during the month"]
["Number of companies signed up to make their shares available for dematerialization","Number",5656,5651,5599,1.0180389359999999,8.8479915000000006E-2,5737,5734,5630,1.9,0.05]
["Number of Depository Participants (registered)","Number",278,278,278,0,0,589,591,599,-1.67,-0.34]
["Number of Clearing Corporations (connected)","Number",4,4,3,33.333333332999999,0,3,3,3,0,0]
["Number of Investors Accounts","Lakh",207.23,205.85,204.83378999999999,1.1698314030000001,0.67039106100000001,278.72000000000003,270.41000000000003,194.87,43.03,3.07]
["Quantity of Shares dematerialized","Crore",56127.827009000001,55719.584557200003,53647.017732499997,4.6243190790000002,0.73267318000000003,23339.52,23608.87,21801.56,7.05,-1.1399999999999999]
["Value of Shares dematerialized","Crore",15328401.3078399,13848796.7330314,13444353.9487742,14.013669725,10.683993730999999,1926202.15,1711021.11,1808048.19,6.53,12.58]
["Quantity of Securities dematerialized #","Crore",60564.870663093003,60119.095985840999,57796.511585562002,4.7898376589999998,0.74148599500000001,25774.23,25988.91,23616.74,9.14,-0.83]
["Value of Securities dematerialized #","Crore",18774769.694811702,17252274.013185602,16344157.9551869,14.871440586,8.8248985639999997,2111062.4500000002,1886366.74,1949032.96,8.31,11.91]
["Quantity of shares settled during the month","Crore",1288.793541,926.98,1352.1689064,-4.686941483,39.031429049000003,1748.82,1167.29,766.9,128.04,49.82]
["Average Quantity of shares settled daily (quantity of shares settled during the month)","Crore",67.83,46.35,67.608445320000001,0.327702669,46.343042070999999,58.29,37.65,25.56,128.04,54.81]
["Value of shares settled during the month in dematerialized form","Crore",348425.85333914199,232311.96,302573.37428590597,15.154168525999999,49.981883558,172500.32,117420.57,68864.23,150.49,46.91]
["Average Value of shares settled daily (value of shares settled during the month)","Crore",18338.202807322999,11615.6,15128.668714295,21.214914237999999,57.875639720000002,5750.01,3787.76,2295.4699999999998,150.49,51.81]
["Training Programmes conducted for representatives of Corporates, DPs and Brokers","Number",1,2,10,-90,-50,0,0,57,-100,"Na"]
["The ratio of dematerialized equity shares to the total outstanding shares market value","Per cent",87.88,88.05,86.898309502999993,1.129700339,-0.19307211799999999,11.13,10.96,11.7,-4.87,1.56]
["Notes: "]
["1. Shares includes only equity shares. "]
["2. Securities include common equity shares, preference shares, debenture, MF units, etc. "]
["3. No. of days taken for calculating Daily Average is 30 days instead of Actual settlement days."]
["4. Quantity and value of shares mentioned are single sided. "]
["5. #Source for listed securities information: Issuer/ NSE/BSE."]
["$ indicates as on November 30, 2020"]
["Source: NSDL and CDSL."]

{"sheet":"61","index":61,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,0,16,7],[17,0,17,6],[18,0,18,7],[0,0,0,9],[1,0,2,0],[1,1,1,5],[1,6,1,10],[14,0,14,7],[15,0,15,7]]}
["Table 61: Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Year/ Month","NSDL",null,null,null,null,"CDSL"]
[null,"Companies Live","DPs Live","DPs\nLocations","Demat \nQuantity \n(million securities)","Demat Value (₹ crore)","Companies Live","DPs Live","DPs\nLocations","Demat \nQuantity \n(million securities)","Demat Value  (₹ crore)"]
["2019-20",30335,279,30874,2351602.9900000002,16032791.785,14762,599,20352,455726.55,1671972.37]
["2020-21$",{"$f":"B13","v":32620},{"$f":"C13","v":278},31268,2376087.14,21505640.532000002,15788,589,20660,458572.33,2318158.59]
["Apr-20",30366,280,30948,2354838.66,18960841.862,38546,595,20519,438715.09,1844619.85]
["May-20",30425,280,30971,2175115.25,17045667.539999999,14818,596,20548,437804.87,1844324.8]
["Jun-20",30594,278,30989,2183559.2999999998,18075718.438999999,14891,597,20589,439758.12,2042069.83]
["Jul-20",30802,278,31024,2283349.31,19011716.522999901,15011,597,20672,445417.07,2068009.11]
["Aug-20",31125,277,31065,2301443.69,19610998.636,15144,594,20689,448038.24,2147565.27]
["Sep-20",31800,277,31221,2330889.2799999998,19770287.741999902,15455,593,20694,454306,2077006.8529999999]
["Oct-20",32285,278,31241,2371425.25,19989147.899999999,15662,591,20706,457347.94,2092306.68]
["Nov-20",32620,278,31268,2376087.14,21505640.532000002,15788,589,20660,458572.33,2318158.59]
["Notes : "]
["1. For CDSL, the current and historical data of Companies Live has been revised to exclude MF schemes count. "]
["2. The Companies Live figure  includes only the number of mutual fund companies and not the mutual fund schemes. "]
["3. DPs Locations represents the total live (main DPs and branch DPs as well as non-live (back office connected collection centres)."]
["$ indicates as on November 30, 2020"]
["Source: NSDL and CDSL."]

{"sheet":"62","index":62,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[21,0,21,9],[3,0,3,9],[10,0,10,9],[17,0,17,9],[18,0,18,9],[19,0,19,9],[20,0,20,9]]}
["Table 62: Depository Statistics"]
["Particulars","Unit","Debt",null,"Equity",null,"Others",null,"Total"]
[null,null,"Listed","Unlisted","Listed","Unlisted","Listed","Unlisted","Listed","Unlisted"]
["NSDL"]
["No.of issuers debt/Companies(equity)","(numbers)",844,2200,5656,23418,239,5028,6739,30646]
["No.of Active Instruments","(numbers)",9019,8530,11466,25106,4883,26757,25368,60393]
["Demat Quantity","(lakhs)",114460.94382,901692.80412999995,5612782.7008999996,11266175.530850001,329243.42158927,5536516.1463736808,6056487.0663092695,17704384.481353682]
["Demat Value","(Rs.crore)",2896176.614397259,618891.90674359095,15328401.307839856,1070211.1334863519,550191.77257454011,1041767.7969282197,18774769.694811653,2730870.8371581621]
["Quantity settled during the month*","(Lakh)",758.08353,2978.7088800000001,128879.3541,201.20706999999999,1915.5790926300001,158.15442999999999,131553.01672262998,3338.0703800000001]
["Value Settled during the month*","(Rs.crore)",103286.6637033,9783.0144220000002,348425.85333914211,67.822060774999983,2459.1113690150014,453.75536556600019,454171.62841145712,10304.591848341001]
["CDSL"]
["No. of Issuers (Debt) / Companies (Equity)","(numbers)",603,466,5737,8792,2484,708,8824,9966]
["No. of Active Instruments","(numbers)",7277,4012,5872,9096,20453,2256,33602,15364]
["Demat Quantity","(lakh)",3513.8,119547.52,2333951.52,1744928.64,239957.58,143824.19,2577422.89,2008300.36]
["Demat Value","(Rs.crore)",73274.850000000006,44334.04,1926202.15,135623,111585.45,27139.1,2111062.4500000002,207096.13]
["Quantity settled during the month","(lakh)",36.590000000000003,0,174881.86,0,21081.09,0,195999.54,0]
["Value Settled during the month","(Rs.crore)",433.93,0,172500.32,0,13091.74,0,186025.99,0]
["Notes: "]
["1. The categories included in Others are Preference Shares, Mutual Fund Units, Warrants, PTCs, Treasury Bills, CPs, CDs and Government Securities."]
["2. * Does not include settlement details for Warehouse reciepts/Commodities."]
["$ indicates as on November 30, 2020"]
["Source: NSDL and CDSL."]

{"sheet":"63","index":63,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,0,17,0],[18,0,18,3],[1,0,2,0],[1,1,2,1],[1,2,1,7],[1,8,1,11],[3,0,5,0],[6,0,8,0],[9,0,11,0],[12,0,14,0]]}
["Table 63: Number of commodities permitted and traded at exchanges"]
["Exchanges","Particulars","Futures",null,null,null,null,null,"Options"]
[null,null,"Agriculture","Metals other than bullion","Bullion ","Energy ","Gems and Stones","Indices","Agriculture","Metals other than bullion","Bullion ","Energy "]
["NCDEX","Permitted for trading",22,1,0,0,0,1,7,0,0,0]
[null,"Contracts floated ",21,0,0,0,0,5,7,0,0,0]
[null,"Traded",15,0,0,0,0,2,3,0,0,0]
["MCX","Permitted for trading",8,5,2,2,0,2,0,2,2,1]
[null,"Contracts floated ",7,5,2,2,0,2,0,2,2,1]
[null,"Traded",5,5,2,2,0,2,0,2,2,1]
["ICEX","Permitted for trading",10,1,0,0,1,0,0,0,0,0,null," "]
[null,"Contracts floated ",10,1,0,0,1,0,0,0,0,0]
[null,"Traded",0,0,0,0,1,0,0,0,0,0]
["BSE","Permitted for trading",8,3,2,2,0,0,0,0,2,0,null,null,null,null," "]
[null,"Contracts floated ",8,3,2,2,0,0,0,0,2,0]
[null,"Traded",2,0,1,0,0,0,0,0,2,0,null,null," "]
["NSE","Permitted for trading",1,1,"2 ",1,0,0,0,1,2,0]
[null,"Contracts floated ",0,0,"2 ",1,0,0,0,0,2,0]
[null,"Traded",0,0,1,0,0,0,0,0,1,0]
["Note: Data is for the month of November 2020."]
["Source: NCDEX, MCX, ICEX, BSE and NSE",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"64","index":64,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 64: Trends in commodity indices"]
["Year/  Month","MCX iCOMDEX ",null,null,null,"NCDEX Nkrishi "]
[null,"Open","High","Low","Close","Open","High","Low","Close"]
["2019-20",10576,10951,7662.5,8255.52,3450.3,3674,2841.01,3179.85]
["2020-21$ ",8252.44,10649.58,7866.92,{"$f":"E13","v":10149.030000000001},3176.19,3879.42,3027.91,{"$f":"I13","v":3771.47}]
["2020-04-01",8252.44,8848.23,7866.92,8007.17,3176.19,3266.84,3027.91,3173.55]
["2020-05-02",8008.34,8720.91,7994.73,8705.89,3173.55,3233.2,3121.31,3188.11,null,null,null,null," "]
["2020-06-03",8707.2099999999991,9102.58,8664.18,9089.06,3188.11,3343.94,3187.68,3238.66]
["2020-07-04",9090.0400000000009,10047.24,8971.64,10001.06,3238.66,3300.47,3219.8,3265.1]
["2020-08-05",10001.56,10649.58,9773.19,10227.33,3265.1,3586.59,3262.37,3582.76]
["2020-09-06",10232.200000000001,10320.48,9540,9714.1,3582.76,3627.98,3427.34,3614.93]
["2020-10-07",9716,10117.290000000001,9545.2900000000009,9873.66,3614.93,3775.65,3606.34,3757.53]
["2020-11-08",9874.4599999999991,10348.870000000001,9836.4500000000007,10149.030000000001,3757.53,3879.42,3697.93,3771.47]
[{"$f":"'[1]1'!A8","v":"$ indicates as on Nov. 30, 2020"}]
["Source: MCX and NCDEX",null,null,null," ",null,null," "]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"65","index":65,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,9],[16,14,16,15],[16,16,16,17],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,18,14],[17,15,18,15],[16,0,18,0],[2,20,2,21],[16,6,16,9],[0,0,0,7],[17,16,18,16],[16,2,16,5],[2,22,2,23],[16,1,18,1],[0,8,0,14],[16,10,16,13],[15,0,15,17],[17,17,18,17],[0,15,0,16],[1,0,1,23],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13],[2,14,2,16],[2,17,2,19]]}
["Table 65: Trends in commodity derivatives at MCX "]
["Futures"]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Metals",null,null,"Bullion",null,null,"Energy",null,null,"BULLDEX Index ",null,null,"METALDEX Index",null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Volume ('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 tonnes)*","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 lots)**","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000 lots)**","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,11353.453030000001,1789350,100919.4925252,54812.698150000004,37596650,1568294.4711345003,267.94053898599998,50829084,2915533.5630957996,1188816.1945911769,205480778,3813027.4302929998,null,null,null,null,null,null,295695862,8397774.9570485,148505,11002.5757954]
["2020-21$",{"$f":"SUM(B7:B14)","v":170},{"$f":"SUM(C7:C14)","v":6582.1111999999994},752117,51320.519986000014,24780.210500000001,9484869,972088.66833000013,286.55665756600001,76790651,3147986.0875661005,261977.043362105,51173496,{"$f":"SUM(N7:N14)","v":1169191.96376},{"$f":"SUM(O7:O14)","v":228.10999999999999},228110,17854.536959999998,26.573999999999998,{"$f":"SUM(S7:S14)","v":26574},{"$f":"SUM(T7:T14)","v":1674.919715},{"$f":"SUM(U7:U14)","v":138455817},{"$f":"SUM(V7:V14)","v":5360116.6963171},{"$f":"W14","v":195315},{"$f":"X14","v":13359.1361655}]
["2020-04-01",18,517.98455999999999,66294,3671.8557304000001,1396.8564999999999,1107524,43536.21014749998,12.250992582999997,3589671,143017.30427060003,54865.717030205,5858278,91621.074682499981,null,null,null,null,null,null,10621767,281846.444831,122686,11614.037363900001]
["2020-05-02",21,617.41380000000015,76863,4106.3184176000004,2275.9254999999998,1497418,79117.77099249998,27.946811002000004,7175006,296836.62684469996,37857.340248795001,6228088,118996.56378499998,null,null,null,null,null,null,14977375,499057.28003979998,135281,14295.7603913]
["2020-06-03",22,877.94938000000013,104714,6367.6581902000007,3261.317500000001,1057395,115127.8131625,37.021260684000005,9153415,364906.40945049998,39902.8655172,6570596,143533.84207250003,null,null,null,null,null,null,16886120,629935.72287569998,152305,14749.869857399999]
["2020-07-04",23,989.46590000000015,114651,7277.3962512000026,3745.4299999999989,1253701,149118.7076275,57.357698916999993,13030913,559967.59815910039,30250.286932489998,6432779,137758.02345750001,null,null,null,null,null,null,20832044,854121.72549530037,144727,15233.6824719]
["2020-08-05",21,742.65032999999971,82203,5824.4504842000024,3733.9474999999998,1216867,152687.29222500001,53.480413654000024,14921463,626980.10613599978,21521.773845489999,4927161,123009.16329750004,26.303999999999998,26304,2119.6345099999999,null,null,null,21173998,910620.6466526998,164840,17478.619636200001]
["2020-09-06",22,858.71834999999965,90864,6838.5318600000001,3672.4005000000006,1176532,146911.16517500006,34.474819904000022,10281771,422378.63415189995,24137.626543720002,7268301,171492.34703249999,65.662000000000006,65662,5182.9009949999991,null,null,null,18883130,752803.57921440003,158034,13881.9313588]
["2020-10-07",21,866.81292999999971,94222,7096.0901250000006,3524.6615000000011,1144077,146202.49811500005,32.130818439000002,9234948,352878.68973930023,24606.357791989998,6904446,187020.73533499998,63.267999999999994,63268,4908.7176399999989,10.741999999999999,10742,658.51666999999998,17451703,698765.2476243003,168203,14247.269590899999]
["2020-11-08",22,1111.1159499999999,122306,10138.218927400003,3169.6714999999995,1031355,139387.21088499998,31.893842382999996,9403464,381020.71881399991,28835.075452215002,6983847,195760.21409749999,72.875999999999976,72876,5643.2838149999998,15.832000000000001,15832,1016.4030449999999,17629680,732966.0495838999,195315,13359.1361655]
[]
["Options"]
["Year / \nMonth","No.of Trading days","Metals",null,null,null,"Bullion",null,null,null,"Energy",null,null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Call Options ",null,"Put Options ",null,"Call Options ",null,"Put Options ",null,"Call Options ",null,"Put Options ",null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value \n(₹ crore)"]
[null,null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)"]
["2019-20",259,18146,1293.2336039999998,12977,969.92868200000009,251533,74410.1388935,278935,90244.629649500013,1729784,69961.987244000004,1393470,54862.742491999998,3684845,291742.67056500004,11844,698.07970150000006]
["2020-21$",{"$f":"SUM(B22:B29)","v":170},{"$f":"SUM(C22:C29)","v":191},23.794452,314,32.581049499999999,165451,56687.597050999997,210802,72599.143244999999,458541,12944.653556000001,378945,{"$f":"SUM(N22:N29)","v":9967.4301309999992},{"$f":"SUM(O22:O29)","v":1214244},152255.19948449999,{"$f":"Q29","v":4646},{"$f":"R29","v":630.12134550000007}]
["2020-04-01",18,3,0.32998,9,0.89101249999999999,6999,1968.6774660000001,10944,3679.8237015,90838,1914.003608,55438,933.48083799999995,164231,8497.2066059999997,11690,1651.0206595]
["2020-05-02",21,31,3.2268599999999998,120,11.252795000000001,11114,4286.8298429999995,22893,8974.6587314999997,62769,1473.6085619999999,65421,1300.1379899999999,162348,16049.714781499999,7927,816.22000949999995]
["2020-06-03",22,11,1.2382219999999999,15,1.6099969999999999,14448,4216.118058,19882,6425.0760920000002,77698,2375.3497889999999,74545,2119.2725380000002,186599,15138.664696,7860,1559.11]
["2020-07-04",23,52,6.4820539999999998,114,13.358575999999999,16126,5916.5598620000001,33590,11775.034136999999,54977,1749.6879269999999,52671,1603.4092559999999,157530,21064.531812000001,7882,1184.07]
["2020-08-05",21,51,6.7336830000000001,43,3.76247,31320,11674.081338,45055,14320.374709,51453,1688.743729,41167,1304.5440189999999,169089,28998.239947999999,9062,3026.3053569999997]
["2020-09-06",22,22,2.912236,7,0.90368099999999996,31513,12055.351627,27693,11639.881839000003,46984,1450.5074050000001,29288,877.65585099999998,135507,26027.212639000005,7154,1279.0107834999999]
["2020-10-07",21,13,1.781925,5,0.66369800000000001,14957,4110.9554779999999,13901,3827.1727709999996,37132,1134.6951429999999,28066,840.25652600000001,94074,9915.5255409999991,9650,2388.1539930000004]
["2020-11-08",22,8,1.0894919999999999,1,0.13882,38974,12459.023379,36844,11957.121263999999,36690,1158.057393,32349,988.67311299999994,144866,26564.103460999999,4646,630.12134550000007]
[{"$f":"'[1]1'!A8","v":"$ indicates as on Nov. 30, 2020"}]
["Note : 1. Natural Gas volume is in Trillion BTU and is not included in volume (\"000 tonnes\") of energy contracts."]
["           2. Options includes both options on futures and goods."]
["Source: MCX"]

{"sheet":"66","index":66,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,19,4,19],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[0,0,0,4],[0,5,0,6],[1,0,4,0],[1,1,4,1],[1,2,1,11],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[1,12,1,19],[2,2,2,4],[2,5,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,19]]}
["Table 66: Trends in commodity derivatives at NCDEX "]
["Year/  Month","No.of Trading days","Futures",null,null,null,null,null,null,null,null,null,"Options"]
[null,null,"Agriculture ",null,null,"Agridex Index ",null,null,"Total ",null,"Open interest at the end of the period",null,"Call options ",null,"Put options ",null,"Total ",null,"Open interest \n  at the end of the period"]
[null,null,"Volume\n('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume\n('000 lots)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value\n(₹ crore)"]
[]
["2019-20",247,95258.745999999999,13080142,441966.96943999996,"Na","Na","Na",13080142,441966.96943999996,93073,2262.96,1518,41.410000000000004,22,0.74,{"$f":"M6+O6","v":1540},42.150000000000006,0,0]
["2020-21$",{"$f":"SUM(B8:B15)","v":166},{"$f":"SUM(C8:C15)","v":36943.756000000008},5775691,176784.422895,5.5550000000000015,5555,294.82137499999999,5781246,177079.24427,{"$f":"K15","v":121177},{"$f":"L15","v":3517.67},{"$f":"SUM(M8:M15)","v":323},{"$f":"SUM(N8:N15)","v":9.9899999999999984},123,6.33,446,16.32,{"$f":"S15","v":188},{"$f":"T15","v":8.0399999999999991}]
["2020-04-01",18,3043.8969999999999,491426,12560.803809999999,"Na","Na","Na",{"$f":"SUM(D8,G8)","v":491426},{"$f":"SUM(E8,H8)","v":12560.803809999999},69860,1730.2965362499999,20,0.68,1,0.02,21,0.70000000000000007,1,0.02]
["2020-05-02",19,2738.5650000000019,417099,11098.384330000001,1.357,1357,69.074012499999995,{"$f":"SUM(D9,G9)","v":418456},11167.4583425,63805,1656.4984999999999,50,1.53,0,0,50,1.53,50,0.13]
["2020-06-03",22,4488.21,664305,18815.042364999998,2.0209999999999999,2021,105.1227375,666326,18920.165102499999,65440,1778.5999999999997,80,2.65,0,0,80,2.65,80,0.26]
["2020-07-04",23,4228.302999999999,624760,18009.332005000007,0.85500000000000032,855,44.821050000000014,625615,18054.153055000006,65264,1959.0900000000004,2,0.1,0,0,2,0.1,0,0]
["2020-08-05",21,4991.0330000000022,761709,23905.798659999997,0.43800000000000017,438,23.934024999999995,762147,23929.732684999995,74187,2323.35889,0,0,0,0,0,0,0,0]
["2020-09-06",22,5512.668000000006,850386,28586.371479999998,0.21100000000000005,211,11.932862500000002,850597,28598.3043425,75975,2328.3580499999998,17,0.98,4,0.09,21,1.07,19,0.1]
["2020-10-07",21,6167.4600000000009,1016400,32532.935704999993,0.41600000000000004,416,24.443999999999996,1016816,32557.379704999992,98368,3032.1699999999996,134,3.62,0,0,134,3.62,59,0.19]
["2020-11-08",20,5773.6199999999963,949606,31275.754540000002,0.25700000000000006,257,15.492687499999999,949863,31291.2472275,121177,3517.67,20,0.43,118,6.22,138,6.6499999999999995,188,8.0399999999999991]
[{"$f":"'[1]1'!A8","v":"$ indicates as on Nov. 30, 2020"}]
["Note: Agridex volume data are in \"000 lots\"."]
["Source: NCDEX",null,null," ",null,null,null," "," ",null,null,null,null,null,null,null,null,null," "]

{"sheet":"67","index":67,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,13,1,14],[1,0,2,0],[1,1,2,1],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,12]]}
["Table 67: Trends in commodity derivatives at ICEX"]
["Year/  Month","No.of Trading days","Agriculture Futures",null,null,"Metals Futures",null,null,"Gems and Stones Futures",null,null,"Total ",null,"Open interest at the end of the period"]
[null,null,"Volume \n('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume\n('000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume \n(in cents)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,821.73900000000015,268376,5353.5233730000009,2450.7099999999996,245071,7437.7322999999997,78395209,78395209,27720.037507274999,78908656,40511.292178220006,8290,19.32]
["2020-21$",{"$f":"SUM(B6:B13)","v":170},{"$f":"SUM(C6:C13)","v":64.862700000000004},15864,307.63081300000005,251.66000000000003,25166,747.52123000000006,1457479,1457479,553.93945785999995,1498509,1609.0921508599999,{"$f":"N13","v":20},{"$f":"O13","v":5.1549999999999999E-3}]
["2020-04-01",18,50.837699999999998,9581,213.02189999999999,159.34,15934,472.86930000000001,655886,655886,250.5,681401,936.39175,14307,19.649999999999999]
["2020-05-02",21,10.79,3048,53.65,83.18,8318,246.82,641368,641368,242.99,652734,543.46,10497,15.64]
["2020-06-03",22,1.321,1321,16.16,8.4,840,25.6,153591,153591,58.103000000000002,155752,99.863,6912,7.45]
["2020-07-04",23,1.7410000000000001,1741,22.481598000000002,0.74,74,2.2319300000000002,5821,5821,2.0950948600000001,7636,26.80862286,3378,5.12059014]
["2020-08-05",21,0.17,170,2.2767149999999998,0,0,0,5,5,1.6379999999999999E-3,175,2.2783529999999996,36,0.48369600000000001]
["2020-09-06",22,3.0000000000000001E-3,3,4.0599999999999997E-2,0,0,0,382,382,0.1153,385,0.156,176,0.05]
["2020-10-07",21,0,0,0,0,0,0,336,336,0.1066,336,0.1066,3,1.0156950000000001E-3]
["2020-11-08",22,0,0,0,0,0,0,90,90,2.7824999999999999E-2,90,2.7824999999999999E-2,20,5.1549999999999999E-3]
[{"$f":"'64'!A14","v":"$ indicates as on Nov. 30, 2020"}]
["Note : Contract size for all diamond futures contract at ICEX is one cent. ",null,null,null,null,null,null,null,null,null,null,null,"   "]
["Source: ICEX",null,null,null,null,null," "]

{"sheet":"68","index":68,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[[18,8,19,8],[18,9,19,9],[29,0,29,8],[16,0,16,9],[17,0,19,0],[17,1,19,1],[17,2,17,5],[17,6,17,7],[17,8,17,9],[18,2,18,3],[18,4,18,5],[18,6,19,6],[18,7,19,7],[0,0,0,17],[1,0,1,17],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13],[2,14,2,15],[2,16,2,17]]}
["Table 68: Trends in commodity derivatives at BSE "]
["Futures"]
["Year/  Month","No.of Trading days","Metal ",null,null,"Bullion ",null,null,"Energy ",null,null,"Agriculture",null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ( '000 tonnes)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,0.874,874,39.275199999999998,0.49412000000000017,41682,8836.5611850000005,422.85129336971352,30995,1246.95,6825.5123999999996,834466,36315.928845000002,908017,46438.715230000002,1,0.03]
["2020-21$",{"$f":"SUM(B7:B14)","v":169},{"$f":"SUM(C7:C14)","v":0},0,0,6.8470000000000011E-4,633,44.33,0.35470668499999997,26,0.57201000000000002,819.22575000000006,111596,4475.6731300000001,112255,4520.5751399999999,{"$f":"Q14","v":91},{"$f":"R14","v":5.03}]
["2020-04-01",18,0,0,0,0,0,0,0,0,0,200.38050000000001,25734,1001.73313,25734,1001.73313,0,0]
["2020-05-02",20,0,0,0,0,0,0,0.35470668499999997,26,0.57201000000000002,165.684,21380,847.49,21406,848.06200999999999,50,2.64]
["2020-06-03",22,0,0,0,6.3370000000000006E-4,123,18.64,0,0,0,314.88175000000001,39937,1565.29,40060,1583.93,86,4.5199999999999996]
["2020-07-04",23,0,0,0,0,0,0,0,0,0,46.964500000000001,7891,323.74,7891,323.74,83,4.12]
["2020-08-01",21,0,0,0,0,0,0,0,0,0,19.513000000000002,3574,153.78,3574,153.78,67,4.08]
["2020-09-01",22,0,0,0,1.0000000000000001E-5,80,4.01,0,0,0,21.349,4042,181.2,4122,185.20999999999998,67,3.86]
["2020-10-01",21,0,0,0,2.0000000000000002E-5,220,11.15,0,0,0,30.783000000000001,5007,236.58,5227,247.73000000000002,83,4.55]
["2020-11-01",22,0,0,0,2.1000000000000002E-5,210,10.53,0,0,0,19.670000000000002,4031,165.86,4241,176.39000000000001,91,5.03]
[]
[]
["Options"]
["Year / \nMonth","No.of Trading days","Bullion",null,null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Call Options ",null,"Put Options ",null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value \n(₹ crore)",null," "]
[null,null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)"]
["2020-21$",{"$f":"SUM(B22:B27)","v":131},{"$f":"SUM(C22:C27)","v":2303483},139752.85999999999,3739867,199400.76999999996,6043350,339153.63,{"$f":"I27","v":43},{"$f":"J27","v":0.01}]
["2020-06-01",22,298958,13332.21,294684,13484.56,593642,26816.769999999997,389,0.11]
["2020-07-01",23,267903,13424.07,1238158,58818.92,1506061,72242.989999999991,376,0.38]
["2020-08-01",21,344179,20187.25,1036730,51483.6,1380909,71670.850000000006,329,0.17]
["2020-09-01",22,377475,29792.17,354405,28539.24,731880,58331.41,38,0.09]
["2020-10-01",21,378630,26409.599999999999,523275,29727.8,901905,56137.399999999994,180,0.54]
["2020-11-01",22,636338,36607.56,292615,17346.650000000001,928953,53954.21,43,0.01]
[{"$f":"'[1]1'!A8","v":"$ indicates as on Nov. 30, 2020"}]
["Note: 1. Conversion factors: Brent Crude Oil (1 Tonne = 7.33 Barrels)"]
[" 2. Option contracts were launched at BSE from June 2020."]
["Source: BSE",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"69","index":69,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,8,19,8],[18,9,19,9],[16,0,16,9],[17,0,19,0],[17,1,19,1],[17,2,17,5],[17,6,17,7],[17,8,17,9],[18,2,18,3],[18,4,18,5],[18,6,19,6],[18,7,19,7],[1,0,1,11],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,9],[2,10,2,11]]}
["Table 69: Trends in commodity derivatives at NSE"]
["Futures"]
["Year/  Month","No.of Trading days","Bullion ",null,null,"Energy",null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Volume ('000  tonnes)","No. of contracts traded","Turnover \n(₹ crore)","Volume ('000  tonnes)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Value\n(₹ crore)"]
["2019-20",259,2.1864300000000003E-2,65928,5773.6021940000001,0.01,79626,588.69708099999991,145554,6362.0044560000006,8,0.33]
["2020-21$",{"$f":"SUM(B7:B14)","v":170},{"$f":"SUM(C7:C14)","v":1.1975000000000002E-3},11930,578.88201000000004,0,0,0,11930,578.88201000000004,{"$f":"K14","v":25},{"$f":"L14","v":1.23}]
["2020-04-01",18,1.2560000000000002E-4,1256,57.360366999999997,0,0,0,1256,57.360366999999997,17,0.76]
["2020-05-02",21,1.6510000000000006E-4,1651,76.517431000000016,0,0,0,1651,76.517431000000016,3,0.14000000000000001]
["2020-06-03",22,4.4740000000000009E-4,4474,209.17937999999998,0,0,0,{"$f":"SUM(D9,G9)","v":4474},{"$f":"SUM(E9,H9)","v":209.17937999999998},18,0.87]
["2020-07-04",23,9.1099999999999992E-5,911,45.493170000000013,0,0,0,911,45.493170000000013,23,1.23]
["2020-08-05",21,1.7479999999999999E-4,1748,92.012484999999998,0,0,0,1748,92.012484999999998,7,0.36]
["2020-09-06",22,1.2850000000000003E-4,1240,65.526607000000013,0,0,0,1240,65.526607000000013,7,0.35]
["2020-10-07",21,2.7900000000000007E-5,279,14.122890999999999,0,0,0,279,14.122890999999999,5,0.25]
["2020-11-08",22,3.7100000000000001E-5,371,18.669679000000002,0,0,0,371,18.669679000000002,25,1.23]
[]
[]
["Options"]
["Year / \nMonth","No.of Trading days","Bullion",null,null,null,"Total",null,"Open interest at the end of the period"]
[null,null,"Call Options ",null,"Put Options ",null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Notional Value \n(₹ crore)"]
[null,null,"No. of contracts traded","Turnover \n(₹ crore)","No. of contracts traded","Turnover \n(₹ crore)"]
["2020-21$",{"$f":"SUM(B22:B27)","v":131},{"$f":"SUM(C22:C27)","v":195890},10035.7752905,130117,6558.0946484999995,326007,16593.869938999997,{"$f":"I27","v":3113},{"$f":"J27","v":157.86000000000001}]
["2020-06-01",22,21403,1028.3461460000001,15232,723.52905750000025,{"$f":"SUM(C22,E22)","v":36635},{"$f":"SUM(D22,F22)","v":1751.8752035000002},1181,56.33]
["2020-07-01",23,72333,3649.5826454999997,52135,2586.1723284999994,124468,6235.7549739999995,2760,140.36000000000001]
["2020-08-01",21,23412,1275.9778905000001,20669,1105.9422065000003,44081,2381.9200970000002,547,27.41]
["2020-09-01",22,19568,1017.1467119999999,14137,717.26084149999974,33705,1734.4075534999997,3787,191.08]
["2020-10-01",21,25980,1340.5805444999994,10221,516.0190255,36201,1856.5995699999994,4333,222.55]
["2020-11-01",22,33194,1724.1413520000006,17723,909.17118899999946,50917,2633.3125410000002,3113,157.86000000000001]
[{"$f":"'[1]1'!A8","v":"$ indicates as on Nov. 30, 2020"}]
["Note: Option contracts were launched at NSE from June 2020."]
["Source: NSE"]

{"sheet":"70","index":70,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,18,1,19],[2,1,2,2],[2,3,2,4],[2,5,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,19],[0,0,0,15],[1,0,3,0],[1,1,1,4],[1,5,1,9],[1,10,1,13],[1,14,1,17]]}
["Table 70: Participant-wise percentage share of turnover at MCX, NCDEX, ICEX, BSE and NSE"]
["Year/ Month","MCX",null,null,null,"NCDEX",null,null,null,null,"ICEX",null,null,null,"BSE",null,null,null,"NSE"]
[null,"Agri Segment",null,"Non-Agri Segment",null,"Agri Segment",null,null,"Agridex Index",null,"Agri Segment",null,"Non-Agri Segment",null,"Agri Segment",null,"Non-Agri Segment",null,"Non-Agri Segment"]
[null,"Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Hedgers","Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Proprietary","Client ","Proprietary","Client "]
["2019-20",38.263375195290081,61.736624804709926,36.876706656365037,63.12329334363497,47.191851662479657,52.042840539860727,0.76530779765961998,"Na","Na",53.656103733085402,46.343849568907345,73.579808958304298,26.420191041695762,65.500177652679895,34.499822347319999,82.051748505711799,17.948251494288101,45.265392816655925,54.734607183344067]
["2020-21$",34.285126333287188,65.714873666712819,38.148493900751532,61.851506099248475,43.094286037717822,55.70276143814317,1.2029525241390182,36.430158345879768,63.569841654120239,64.00975213327915,35.99024786672085,68.843188253237713,31.156811746762301,63.9987911179782,36.0012088820217,50.244647333845201,49.7553526661547,56.832592292048659,43.167407707951341]
["2020-04-01",41.228984003003951,58.771015996996049,36.838343802546476,63.161656197453532,42.834718314098083,55.823640975250612,1.3416407106513035,"Na","Na",77.480720944400218,22.519279055599792,80.365906794025037,19.634093205974963,50.014821811873098,49.985178188126802,0,0,76.107388748053168,23.892611251946835]
["2020-05-02",41.821318486638738,58.178681513361262,36.500108639509506,63.499891360490487,44.723323322684053,53.650266114905719,1.6264105624102139,42.524685025355978,57.475314974644029,58.535423799125596,41.464576200874404,57.643030362191347,42.35696963780866,59.5197592974015,40.480240702598401,53.888918025908602,46.111081974091299,66.819481302240789,33.180518697759211]
["2020-06-03",34.190765817968924,65.809234182031091,36.838868889630874,63.161131110369126,40.512302721036029,57.699914565140674,1.787782713823292,37.108271890274899,62.891728109725101,2.0756957666838565,97.92430423331615,37.154911925855679,62.845088074144329,57.377483830409297,42.622516169590597,50.469893645724902,49.530106354274999,74.497235354489561,25.502764645510439]
["2020-07-04",32.390231614931196,67.609768385068804,39.618964978277624,60.381035021722383,41.66,56.87,1.48,43.08,56.92,0.45148703400000001,99.548512970000004,27.295211559999998,72.704788440000002,93.097980103871095,6.9020198961288397,0,0,54.198448050518522,45.801551949481471]
["2020-08-05",33.036061151514595,66.963938848485398,41.253630515101946,58.746369484898054,43.489080705325406,55.321404058039533,1.1895152366350599,23.829255630843537,76.170744369156466,0.89602782957023608,99.10397217042977,100,0,94.835678720969895,5.1643212790300499,0,0,58.040692678827412,41.959307321172588]
["2020-09-06",33.385596883071301,66.614403116928671,39.143028076217234,60.856971923782766,45.33939711994536,53.996649498868123,0.66395338118652347,17.823101958980924,82.176898041019072,0,100,1.34,98.66,98.334216970277396,1.66578302972259,50,50,53.400583023714432,46.599416976285561]
["2020-10-07",35.29628375034202,64.703716249657973,37.670794055525562,62.329205944474438,43.823944307641462,55.189667542792698,0.98638814956585819,31.873286900670923,68.126713099329066,0,0,0,100,93.124887750245804,6.8751122497541104,50,50,53.128142534233469,46.871857465766531]
["2020-11-08",30.753857350362036,69.24614264963796,34.732337797457554,65.267662202542454,41.889619260005915,56.895457053615772,1.2149236863783106,26.411008419294586,73.588991580705425,0,0,1.2354012693368661,98.764598730663138,69.384427477749497,30.6155725222504,50,50,53.119608528144667,46.88039147185534]
[{"$f":"'64'!A14","v":"$ indicates as on Nov. 30, 2020"}]
["Source: MCX, NCDEX, ICEX, BSE and NSE",null,null,null,null,null," ",null,null,null,null," "]

{"sheet":"71","index":71,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,0,48,10],[3,0,3,11],[4,1,4,11],[8,1,8,11],[15,1,15,11],[22,1,22,11],[30,0,30,1],[31,0,31,11],[32,1,32,11],[36,1,36,11],[40,1,40,11],[43,0,43,1],[0,0,0,11],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11]]}
["Table 71: Commodity-wise turnover and trading volume at MCX"]
["Sr.No","Name of the Commodity","2019-20",null,"2020-21$",null,"2019-11-01",null,"2020-10-01",null,"2020-11-01"]
[null,null,"Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)"]
["Futures"]
["A","Bullion",null,null,null,null,null,null,null,null,null,null,"TO","Vol"]
[null,"Gold",4.7192239860000003,1776343.7174287003,2.9918515659999998,1483746.8696786996,0.34473030600000004,130874.77632160002,0.31007643899999998,157055.1992835,0.36770438299999991,184689.95328140011,{"$f":"(L6-J6)/J6*100","v":17.595567751957503}]
[null,"Silver",263.221315,1139189.8456671019,283.56480599999992,1664239.2178874004,20.639647,92565.99514649999,31.820741999999999,195823.4904558,31.526138000000003,196330.76553259994,{"$f":"(L7-J7)/J7*100","v":0.25904710186668717}]
[null,"Total for A",{"$f":"SUM(C6:C7)","v":267.94053898599998},{"$f":"SUM(D6:D7)","v":2915533.5630958024},{"$f":"SUM(E6:E7)","v":286.5566575659999},{"$f":"SUM(F6:F7)","v":3147986.0875661001},20.984377305999999,223440.77146810002,32.130818439000002,352878.6897393,31.893842383000003,381020.71881400002,{"$f":"(L8-J8)/J8*100","v":7.9749868419344949},{"$f":"(K8-I8)/I8*100","v":-0.73753507539777108}]
["B","Metals other than Bullion"]
[null,"Aluminium",5357.2539999999999,74320.623694999929,1625.124,23444.960230000001,335.81200000000007,4453.7915850000009,235.125,3519.3762749999996,269.62500000000006,4303.1669750000001,{"$f":"(L10-J10)/J10*100","v":22.270727502702179}]
[null,"Copper",10467.644,454929.94498750014,7385.0049999999992,364559.85132500017,654.62500000000011,28701.699375000004,1046.1624999999997,54869.667625000002,914.89249999999981,49905.679224999985,-9.0468716412240457]
[null,"Lead",11670.041000000001,171197.97619000002,3082.049,45078.493235000031,616.19299999999987,9560.7693950000012,452.05000000000007,6703.9051500000005,327.90499999999997,5073.6606500000007,-24.317833613740785]
[null,"Nickel",4210.5061500000002,421940.80258700001,3515.1195000000002,371324.41067999991,228.95625000000001,25272.811524999997,492.66899999999998,55614.897914999987,459.51899999999989,54552.980084999988,-1.9094125311944283]
[null,"Zinc",23107.257999999998,445905.12367500056,9172.9130000000005,167680.95286000002,1453.2900000000002,27646.509775000006,1298.6550000000002,25494.651150000002,1197.73,25551.723949999996,0.2238618589609313]
[null,"Total for  B",{"$f":"SUM(C10:C14)","v":54812.703150000001},{"$f":"SUM(D10:D14)","v":1568294.4711345006},{"$f":"SUM(E10:E14)","v":24780.210500000001},{"$f":"SUM(F10:F14)","v":972088.66833000025},3288.8762500000003,95635.581655000016,3524.6614999999997,146202.49811499999,3169.6714999999999,139387.21088499995,-4.6615395207811536,{"$f":"(K15-I15)/I15*100","v":-10.071605457715579}]
["C","Agricultural commodities"]
[null,"Cardamom",1.1468000000000005,313.30658700000026,2.5299999999999986E-2,4.233368000000004,9.9000000000000005E-2,26.231988000000001,1E-3,0.14822499999999997,6.0000000000000006E-4,8.8104000000000002E-2,-40.560634171023771]
[null,"Cotton",3045.1207499999996,37145.596675000023,583.1255000000001,5801.8882000000021,101.53675000000001,1147.7059499999998,41.280250000000002,470.26760000000007,72.398750000000007,853.03987500000005,81.394566625470247]
[null,"CPO",8158.9499999999989,52534.080239999996,5952.8899999999994,44353.475169999991,760.27999999999986,4918.3980700000002,818.38,6472.1449599999996,1033.54,9173.6456900000012,41.740423718816118]
[null,"Mentha Oil",82.455479999999937,10577.78167320001,9.7703999999999986,973.06228800000008,6.90984,881.90764200000001,1.2916799999999999,121.61285999999998,0.91259999999999997,86.718848399999999,-28.692698782020248]
[null,"Kapas",65.78,348.72735,36.299999999999997,187.86096000000001,7.0960000000000001,38.315159999999999,5.8599999999999994,31.91648,4.2640000000000002,24.726410000000001,-22.527766219833762]
[null,"Total for C",{"$f":"SUM(C17:C21)","v":11353.453029999999},{"$f":"SUM(D17:D21)","v":100919.49252520002},{"$f":"SUM(E17:E21)","v":6582.1112000000003},{"$f":"SUM(F17:F21)","v":51320.519985999992},875.92158999999992,7012.5588100000004,866.81293000000005,7096.0901249999997,1111.1159499999999,10138.218927400001,42.87049274758192,{"$f":"(K22-I22)/I22*100","v":28.184053507369789}]
["D","Energy",null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Crude Oil",1188816.1945911769,3353599.834393003,261977.04336210512,487571.69050999993,97379.114645284993,291321.59420600004,24606.357791989998,52340.207009999998,28835.075452215002,64144.717960000009,22.553428089699125," "]
[null,"Natural Gas (trln. Btu)",29170.883750000001,459427.59590000007,39963.223749999997,681620.27325000043,3258.3850000000002,61857.812125000004,7970,134680.52832500002,6087.7950000000001,131615.49613749998,-2.2757797475398616]
[null,"Total for D",null,{"$f":"SUM(D24:D25)","v":3813027.4302930031},null,{"$f":"SUM(F24:F25)","v":1169191.9637600004},null,{"$f":"SUM(H24:H25)","v":353179.40633100003},null,{"$f":"SUM(J24:J25)","v":187020.73533500003},null,{"$f":"SUM(L24:L25)","v":195760.21409749999},{"$f":"(L26-J26)/J26*100","v":4.6729998932179404},{"$f":"(K26-I26)/I26*100","v":{"$error":"#DIV/0!"}}]
["E","Index Futures"]
[null,"iCOMDEX Bullion","Na","Na",228.11000000000004,17854.536960000001,"Na","Na",63.268000000000001,4908.7176399999998,72.875999999999976,5643.2838149999998,{"$f":"(L28-J28)/J28*100","v":14.964522893192935},{"$f":"(K28-I28)/I28*100","v":15.18619207182142}]
[null,"iCOMDEX Metal","Na","Na",26.573999999999998,1674.9197149999998,"Na","Na",10.741999999999999,658.51667000000009,15.832000000000001,1016.4030449999999,{"$f":"(L29-J29)/J29*100","v":54.347352360874901},{"$f":"(K29-I29)/I29*100","v":47.384099795196441}]
[null,"Total for E",null,{"$f":"SUM(D28:D29)","v":0},null,{"$f":"SUM(F28:F29)","v":19529.456675000001},null,{"$f":"SUM(H28:H29)","v":0},null,{"$f":"SUM(J28:J29)","v":5567.2343099999998},null,{"$f":"SUM(L28:L29)","v":6659.6868599999998}]
["Grand Total (A+B+C+D+E)",null,{"$f":"SUM(C8,C15,C22,C24)","v":1255250.291310163},{"$f":"SUM(D8,D15,D22,D26,D30)","v":8397774.9570485055},{"$f":"SUM(E8,E15,E22,E24)","v":293625.92171967111},{"$f":"SUM(F8,F15,F22,F26,F30)","v":5360116.6963171},{"$f":"G30+G24+G22+G15+G8","v":101564.89686259099},{"$f":"SUM(H8,H15,H22,H26,H30)","v":679268.3182641},{"$f":"I30+I24+I22+I15+I8","v":29029.963040428996},{"$f":"SUM(J8,J15,J22,J26,J30)","v":698765.24762429995},{"$f":"K30+K24+K22+K15+K8","v":33147.756744597995},{"$f":"SUM(L8,L15,L22,L26,L30)","v":732966.0495838999},4.8944623499634101,{"$f":"(K31-I31)/I31*100","v":14.184632954696822}]
["Options",null,null,null,null,null,null,null,null,null,null,null," "]
["F","Bullion",null,null,null,null,null,null,null,null,null,null," "," "]
[null,"Gold ",0.3771590000000003,144222.89055500002,0.21011979999999988,104463.72402250004,2.4373999999999996E-2,9280.9016050000009,1.1096100000000001E-2,5703.7147600000008,4.0811499999999994E-2,20796.047842499996,{"$f":"(L34-J34)/J34*100","v":264.60532683615463},null," "]
[null,"Silver",4.5992700000000006,20431.882590000019,4.1127599999999997,24823.013647499982,0.41607,1909.589307,0.34869000000000006,2234.4132840000002,0.57080999999999993,3620.0965244999993,{"$f":"(L35-J35)/J35*100","v":62.015530001655641}]
[null,"Total  of F",{"$f":"SUM(C34:C35)","v":4.9764290000000013},{"$f":"SUM(D34:D35)","v":164654.77314500004},{"$f":"SUM(E34:E35)","v":4.3228797999999999},{"$f":"SUM(F34:F35)","v":129286.73767000003},0.440444,11190.490912000001,0.35978610000000005,7938.128044000001,0.61162149999999993,24416.144366999997,207.58063149982613]
["G","Metals ",null,null,null,null,null,null,null,null,null,null," "," "]
[null,"Copper",23.172499999999999,1023.3735255000004,1.1549999999999998,52.696722499999979,0.80749999999999988,35.957005000000002,4.5000000000000005E-2,2.4456225000000003,2.2499999999999996E-2,1.2283099999999998,-49.775159494157435]
[null,"Zinc",59.388000000000019,1239.7838420000003,0.21500000000000002,3.6787550000000002,2.38,45.729084999999991,0,0,0,0,{"$error":"#DIV/0!"}]
[null,"Total of G",{"$f":"SUM(C38:C39)","v":82.560500000000019},{"$f":"SUM(D38:D39)","v":2263.1573675000009},{"$f":"SUM(E38:E39)","v":1.3699999999999999},56.375477499999981,3.1875,81.686089999999993,4.5000000000000005E-2,2.4456225000000003,2.2499999999999996E-2,1.2283099999999998,-49.775159494157435]
["H","Energy"]
[null,"Crude Oil",42609.19570651,124824.73345399999,11425.457191590009,22912.083687000002,3316.9168284499997,9947.3149870000016,889.46795287000009,1974.9516689999996,941.86904503500011,2146.7305060000003,8.6978754820354425]
[null,"Total for H",{"$f":"C42","v":42609.19570651},{"$f":"D42","v":124824.73345399999},11425.457191590009,22912.083687000002,3316.9168284499997,9947.3149870000016,889.46795287000009,1974.9516689999996,941.86904503500011,2146.7305060000003]
["Grand Total (F+G+H)",null,{"$f":"SUM(C36,C40,C43)","v":42696.732635510001},{"$f":"SUM(D36,D40,D43)","v":291742.66396650003},11431.15007139001,152255.19683450004,3320.5447724499995,21219.491989000002,889.87273897000011,9915.5253355000004,942.5031665350001,26564.103182999996,167.90414309057357]
[{"$f":"'64'!A14","v":"$ indicates as on Nov. 30, 2020"}]
["Note : 1. Natural Gas volume is in trillion BTU and is not included for computing the  total volume in \"000 tonnes\".",null,null,null,null,null,null,null,null," "]
["           2. iCOMDEX Bullion volumes are in '000 lots and is not included for computing the total volume in \"000 tonnes\".",null,null,null,null,null,null,null,null,null,null," "]
["           3. Options includes both options on futures and goods"]
["           4.Conversion factors: Cotton (1 Bale=170 kg), Crude Oil (1 Tonne = 7.33Barrels)"]
["           4. Trading in iCOMDEX Bullion Futures and iCOMDEX Metal Futures launched on 24th Aug, 2020 and 19th Oct. 2020 respectively."]
["Source : MCX"]

{"sheet":"72","index":72,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,1,3,11],[25,1,25,11],[0,0,0,11],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11]]}
["Table 72: Commodity-wise turnover and trading volume at NCDEX "]
["Sr.No","Name of Agri. Commodity ","2019-20",null,"2020-21$",null,"2019-11-17",null,"2020-10-18",null,"2020-11-18"]
[null,null,"Volume \n('000 tonnes)","Value\n(₹ crore)","Volume \n('000 tonnes)","Value\n(₹ crore)","Volume \n('000 tonnes)","Value\n(₹ crore)","Volume \n('000 tonnes)","Value \n( crore)","Volume ('000 tonnes)","Value\n(₹ crore)"]
["A","Futures",null,null,null,null,null,null,null,null,null,null,"TO","VOT"]
[null,"AGRIDEX   Index ","Na","Na",5.5550000000000015,294.82137499999999,"Na","Na",0.41600000000000004,24.443999999999996,0.25700000000000006,15.492687499999999,{"$f":"(L5-J5)/J5*100","v":-36.619671494027159},{"$f":"(K5-I5)/I5*100","v":-38.22115384615384}]
[null,"Barley",102.46,185.62521999999996,30.390000000000004,44.963865000000006,0.72,1.2799700000000001,1.9900000000000002,2.6960999999999999,1.01,1.4611700000000001,{"$f":"(L6-J6)/J6*100","v":-45.804309929156929},{"$f":"(K6-I6)/I6*100","v":-49.246231155778894}]
[null,"Bajra",4.29,7.3723200000000002,"Na","Na","Na","Na","Na","Na","Na","Na"]
[null,"Castorseed",11053.960000000001,60060.970820000002,1300.5900000000001,5318.5655500000003,369.52499999999998,1608.6262499999996,201.14999999999998,858.66199999999992,187.63,878.86197999999979,{"$f":"(L8-J8)/J8*100","v":2.3524949281556502},{"$f":"(K8-I8)/I8*100","v":-6.7213522247079212}]
[null,"Chana",10985.99,47542.733989999993,5993.56,28691.252099999998,606.71,2719.14788,1044.2600000000002,5712.455509999998,712,3719.7358799999997,{"$f":"(L9-J9)/J9*100","v":-34.883766298251636},-31.817746538218465]
[null,"Cotton seed oil cake",16806.920000000002,39603.763459999995,5941.22,11637.345940000001,1314.45,2836.6181299999998,511.46999999999997,942.22069999999997,757.18000000000006,1519.0503299999996,61.220224730787557,48.039963243200987]
[null,"Coriander",2035.7499999999998,13715.272800000001,247.88499999999996,1554.1263300000003,137.52000000000001,950.39071999999987,21.225000000000001,142.88784000000001,23.105,151.60452000000001,{"$f":"(L11-J11)/J11*100","v":6.1003651535358054},8.8574793875147169]
[null,"Guar seed",15063.849999999999,67368.65558999998,4469.2700000000004,17563.153410000003,432.70499999999998,3431.9451849999991,852.57499999999993,3559.3892850000002,585.97,2430.2790300000001,-31.722022082785472,-31.270562707093209]
[null,"Guargum",5943.43,38586.70630999998,2650.2599999999998,15994.711755,1455.21,6190.1106100000006,405.70000000000005,2592.9850899999992,317.97500000000002,2003.0804150000001,-22.750021867653672,-21.623120532413118]
[null,"Jeera",607.67700000000002,10064.350060000001,138.48599999999999,1934.5861949999999,40.364999999999988,660.53362500000014,21.183,296.77267499999999,19.670999999999999,280.47296999999998,{"$f":"(L14-J14)/J14*100","v":-5.4923200055395993},-7.1377991785866044]
[null,"Kapas",1096.299,6893.0793900000008,355.54199999999997,1926.9088300000003,103.75600000000001,559.10094000000004,97.772000000000006,536.67622000000006,114.30399999999999,669.0406200000001,24.663734867924656,16.908726424743261]
[null,"Maize",68.64,135.77198999999999,17.38,22.245220000000003,0.62,1.1932399999999999,0.10999999999999999,0.14336999999999997,"Na","Na",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Moong",15.334999999999999,95.276885000000021,0.02,0.14129999999999998,0.29500000000000004,2.00244,0.01,7.4999999999999997E-2,"Na","Na",0,0]
[null,"Paddy Basmati Rice",0.96000000000000008,3.7552000000000003,"Na","Na","Na","Na","Na","Na","Na","Na"]
[null,"RM seed",6650.54,26874.543099999999,4420.5599999999995,23045.52547,439.41,1882.37102,690.22,3915.8434199999997,664.3599999999999,4065.8574800000001,3.8309514428950391,-3.7466315087943158]
[null,"Soy bean",15880.070000000003,61991.571400000001,6430.7699999999995,25989.681855000003,2105.84,8447.8473900000008,1461.8499999999997,6127.7297299999991,1500.1999999999998,6572.1852699999999,{"$f":"(L20-J20)/J20*100","v":7.2531844513971562},2.6233881725211305]
[null,"Refined Soy Oil",7463.0399999999991,60031.728280000003,4533.835,40675.441124999998,629.96,5044.9067249999989,789.80999999999983,7444.1192850000007,844.62000000000012,8721.7167849999987,{"$f":"(L21-J21)/J21*100","v":17.162507088976582},6.9396437117788201]
[null,"Turmeric",1297.855,8443.7554899999996,368.18,2121.6325099999999,71.17,430.79612999999995,68.054999999999993,399.56277999999998,0,0,-100,-100]
[null,"Wheat",181.68,362.16701999999992,45.594999999999985,262.41224,1.5200000000000002,3.2743799999999994,0,0,45.584999999999987,262.39424000000002,{"$f":"(L23-J23)/J23*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"Sesameseed","Na","Na",0.19500000000000001,1.7292000000000001,"Na","Na",8.0000000000000016E-2,0.7167,"Na","Na",{"$f":"(L24-J24)/J24*100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[" ","Total for A",{"$f":"SUM(C6:C24)","v":95258.745999999985},{"$f":"SUM(D5:D24)","v":441967.09932500002},{"$f":"SUM(E6:E24)","v":36943.738000000005},{"$f":"SUM(F5:F24)","v":177079.24426999997},7709.7760000000007,34770.144635000004,{"$f":"SUM(I6:I24)","v":6167.4599999999991},32557.379704999999,{"$f":"SUM(K6:K24)","v":5773.61},31291.233377500001,{"$f":"(L25-J25)/J25*100","v":-3.8889687652153109},{"$f":"(K25-I25)/I25*100","v":-6.3859352148210053}]
["B","Options"]
[null,"Chana",0.29000000000000004,1.27,0.34,2.2799999999999998,0,0,0,0,0.16,0.85,{"$error":"#DIV/0!"},null," "]
[null,"Guargum",1.7150000000000001,11.71,0.90999999999999992,5.9700600000000001,"Na","Na",0.21,1.56,0,0,-100,null," "]
[null,"Guarseed",6.6250000000000009,29.17,0.57000000000000006,2.5073250000000002,0.17,0.74,0.46,2.06,0.1,0.43,-79.126213592233015," "," "]
[null,"Soybean","Na","Na",0.02,0.09,"Na","Na","Na","Na",0,0,{"$error":"#VALUE!"}," "]
[null,"RM Seed","Na","Na",1.04,5.47,"Na","Na","Na","Na",1.02,5.37]
[null,"Total for B",{"$f":"SUM(C27:C31)","v":8.6300000000000008},{"$f":"SUM(D27:D31)","v":42.150000000000006},{"$f":"SUM(E27:E31)","v":2.88},16.317384999999998,0.17,0.74,0.67,3.62,1.28,6.65,83.701657458563545," "]
[{"$f":"'64'!A14","v":"$ indicates as on Nov. 30, 2020"},null,null,null,null,null,null,null," "," ",null," "]
["Note: AGRIDEX volume are in '000 lots and is not included for computing the total volume in \"000 tonnes\" .",null,null,null,null,null,null," ",null," ",null,null,null," "]
["Source: NCDEX",null,null,null,null,null," ",null,null,null," "]

{"sheet":"73","index":73,"n_rows":82,"n_cols":21,"rows_kept":82,"cut":false,"hidden":false,"merged":[[79,1,79,11],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[19,1,19,11],[37,1,37,11],[63,1,63,11],[78,1,78,11]]}
["Table 73: Commodity-wise turnover and trading volume at ICEX, BSE and NSE",null,null,null,null,null,null,null," "," "]
["Sr.No","Name of the Commodity","2019-20",null,"2020-21$",null,"2019-11-01",null,"2020-10-01",null,"2020-11-01"]
[null,null,"Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)","Volume\n('000 tonnes)","Value\n(₹ crore)"]
[1,"ICEX Futures",null,null,null,null,"ICEX"]
["A","Gems & Stones",null,null,null,null,null,null,null,null,null,null,"TO","VOT"]
[null,"Diamond 1 CT",778271.69,27629.265237410007,14575.9,554.056107,63286.33,2263.8509169999998,3.36,0.1066,0.8,2.6106999999999998E-2]
[null,"Diamond .5 CT",5676.0560000000005,90.721409925000003,0.19,3.1949999999999999E-3,0.05,7.76E-4,"Na","Na",0.1,1.7179999999999999E-3]
[null,"Diamond .3 CT",4.29,4.2880000000000001E-2,"Na","Na",2.88,0.03,"Na","Na","Na","Na"]
[null,"Total for 1A",null,{"$f":"SUM(D6:D8)","v":27720.029527335009},null,{"$f":"SUM(F6:F8)","v":554.059302},null,{"$f":"SUM(H6:H8)","v":2263.8816929999998},null,{"$f":"SUM(J6:J8)","v":0.1066},null,{"$f":"SUM(L6:L8)","v":2.7824999999999999E-2},{"$f":"(L9-J9)/J9*100","v":-73.897748592870542}]
["B","Metal other than gems & stones"]
[null,"Steel Long",2450.71,7437.7305900000001,251.66,747.51869999999997,214.69,607.2992200000001,0,0,0,0]
[null,"Total for 1B",{"$f":"SUM(C11)","v":2450.71},{"$f":"SUM(D11)","v":7437.7305900000001},{"$f":"SUM(E11)","v":251.66},747.51869999999997,214.69,607.2992200000001,{"$f":"SUM(I11)","v":0},{"$f":"SUM(J11)","v":0},0,0,{"$f":"(L12-J12)/J12*100","v":{"$error":"#DIV/0!"}},{"$f":"(K12-I12)/I12*100","v":{"$error":"#DIV/0!"}}]
["C","Agricultural Commodities",null," "]
[null,"Isabgulseed ",32.909999999999997,319.81,"Na","Na",6.0999999999999999E-2,0.50083,"Na","Na","Na","Na"]
[null,"Pepper Mini",27.004000000000001,941.64445999999998,"Na","Na",7.8E-2,2.3722099999999999,"Na","Na","Na","Na"]
[null,"Rubber ",146.98099999999999,2034.2129190000003,10.42,122.58546199999999,2.6339999999999999,34.434864999999988,0,0,0,0]
[null,"Paddy Basmati",614.86,2057.8877600000001,54.44,185.04285999999999,71.16,230.94616000000002,"Na","Na","Na","Na"]
[null,"Total for 1C",{"$f":"SUM(C14:C17)","v":821.755},{"$f":"SUM(D14:D17)","v":5353.5551390000001},{"$f":"SUM(E14:E17)","v":64.86},307.62832199999997,73.932999999999993,268.25406500000003,0,0,{"$f":"SUM(K12,K14:K17)","v":0},0,{"$f":"(L18-J18)/J18*100","v":{"$error":"#DIV/0!"}},{"$f":"(K18-I18)/I18*100","v":{"$error":"#DIV/0!"}}]
[null,"Total - ICEX Futures (1A+1B+1C)",{"$f":"SUM(C12,C18)","v":3272.4650000000001},{"$f":"SUM(D9,D12,D18)","v":40511.315256335016},{"$f":"SUM(E12,E18)","v":316.52},{"$f":"SUM(F9,F12,F18)","v":1609.206324},{"$f":"SUM(G12,G18)","v":288.62299999999999},{"$f":"SUM(H9,H12,H18)","v":3139.4349780000002},{"$f":"SUM(I12,I18)","v":0},{"$f":"SUM(J9,J12,J18)","v":0.1066},{"$f":"SUM(K12,K18)","v":0},{"$f":"SUM(L9,L12,L18)","v":2.7824999999999999E-2},{"$f":"(L19-J19)/J19*100","v":-73.897748592870542},{"$f":"(K19-I19)/I19-100","v":{"$error":"#DIV/0!"}}]
[null,"NSE",null,null,null,null,null,null,null,null,null,null,null," "]
[2,"NSE Futures",null,null,null,null,null,null,null,null," "," "]
["A","Bullion"]
[null,"Gold",1.0151E-2,3847.8082600000012,5.0000000000000004E-6,2.5385900000000001,1.7089999999999994E-3,649.80921000000012,0,0,0,0]
[null,"Gold Mini",5.5579000000000002E-3,1903.4624079999994,1.1925E-3,576.34342000000004,5.0700000000000006E-5,19.27401399999999,2.7900000000000007E-5,14.122890999999999,3.7100000000000001E-5,18.669679000000002]
[null,"Silver",5.94E-3,22.331526,0,0,0,0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Total for 2A",{"$f":"SUM(C23:C25)","v":2.1648900000000002E-2},{"$f":"SUM(D23:D25)","v":5773.602194000001},{"$f":"SUM(E23:E25)","v":1.1975E-3},578.88201000000004,{"$f":"SUM(G23:G25)","v":1.7596999999999995E-3},669.08322400000009,2.7900000000000007E-5,14.122890999999999,3.7100000000000001E-5,18.669679000000002,{"$f":"(L26-J26)/J26*100","v":32.194456503275447},{"$f":"(K26-I26)/I26*100","v":32.974910394265201}]
["B","Energy",null,null,null,null,null,null,null,null,null," "]
[null,"BR Crude",8.2114597544338298E-4,256.75670000000002,0,0,3.2332878581173262E-5,10.571980000000002,0,0,0,0]
[null,"BR Crude Mini",1.00418826739427E-2,331.94038100000012,0,0,1.2638472032742154E-3,41.356746999999999,0,0,0,0]
[null,"Total for 2B",{"$f":"SUM(C28:C29)","v":1.0863028649386083E-2},588.69708100000014,0,0,1.2961800818553886E-3,51.928727000000002,{"$f":"SUM(I28:I29)","v":0},0,0,0]
[null,"Total -NSE Futures (2A+2B)",{"$f":"SUM(C26,C30)","v":3.2511928649386082E-2},{"$f":"SUM(D26,D30)","v":6362.2992750000012},{"$f":"SUM(E26,E30)","v":1.1975E-3},{"$f":"SUM(F26,F30)","v":578.88201000000004},3.0558800818553883E-3,721.01195100000007,2.7900000000000007E-5,14.122890999999999,3.7100000000000001E-5,18.669679000000002,{"$f":"(L31-J31)/J31*100","v":32.194456503275447},{"$f":"(K31-I31)/I31*100","v":32.974910394265201}]
[null,"NSE Options"]
["C","Bullion"]
[null,"Gold Mini","Na","Na",3.2600699999999989E-2,16593.869938999997,0,0,3.6201000000000007E-3,1856.5995699999994,5.0916999999999863E-3,2633.3125410000007]
[null,"Total for 2C",{"$f":"C34","v":"Na"},{"$f":"D34","v":"Na"},3.2600699999999989E-2,16593.869938999997,0,0,3.6201000000000007E-3,1856.5995699999994,5.0916999999999863E-3,2633.3125410000007]
[null,"Total - NSE Options( 2C)","Na","Na",{"$f":"SUM(E34)","v":3.2600699999999989E-2},{"$f":"SUM(F35)","v":16593.869938999997},{"$f":"SUM(G35)","v":0},0,3.6201000000000007E-3,1856.5995699999994,5.0916999999999863E-3,2633.3125410000007,{"$f":"(L36-J36)/J36*100","v":41.835244581038097},{"$f":"(K36-I36)/I36*100","v":40.650810751083824}]
[null,null,null,null,null,null,null,null,null,null," "]
[null," "]
[3,"BSE Futures ",null,null,null,null,null,null,null,null,null," "]
["A","Bullion"]
[null,"Gold",2.0114999999999997E-2,6765.6868699999995,3.0000000000000001E-5,12.07,2.5799999999999998E-4,98.018299999999996,0,0,0,0," ",null," "]
[null,"Silver",0.47571000000000002,1887.0314720000001,5.9999999999999995E-4,2.91,9.3000000000000005E-4,4.128762,0,0,0,0]
[null,"Silver KG",1.0000000000000001E-5,3.7500000000000006E-2,0,0,0,0,0,0,0,0]
[null,"Silver M",1.0000000000000001E-5,3.7490000000000002E-2,0,0,0,0,0,0,0,0]
[null,"Gold M",5.6940000000000007E-4,183.77492000000001,4.3015700000000004E-2,29.356521000000001,0,0,2.1999999999999999E-5,11.15118,2.1000000000000002E-5,10.52684]
[null,"Total for 3A",{"$f":"SUM(C41:C45)","v":0.49641440000000003},{"$f":"SUM(D41:D45)","v":8836.5682520000009},{"$f":"SUM(E41:E45)","v":4.3645700000000003E-2},44.336521000000005,{"$f":"SUM(G41:G45)","v":1.188E-3},102.14706199999999,2.1999999999999999E-5,11.15118,2.1000000000000002E-5,10.52684,{"$f":"(L46-J46)/J46*100","v":-5.598869357323621},{"$f":"(K46-I46)/I46*100","v":-4.5454545454545334}]
["B","Metals other than Bullion"]
[null,"Copper",0.874,39.268440000000005,0,0,0,0,0,0,0,0]
[null,"Total for 3B",{"$f":"SUM(C48)","v":0.874},{"$f":"SUM(D48)","v":39.268440000000005},{"$f":"SUM(E48)","v":0},0,0,0,0,0,0,0,{"$f":"(L49-J49)/J49*100","v":{"$error":"#DIV/0!"}},{"$f":"(K49-I49)/I49*100","v":{"$error":"#DIV/0!"}}]
["C","Agricultural Cmmodities",null,null,null,null,null,null,null,null,null," "]
[null,"Guar Gum",0.38,3.3538600000000001,0,0,0,0,0,0,0,0]
[null,"Guar Seed",5273.0100000000011,22019.759270000002,467.96999999999997,1652.09934,635.45000000000005,2687.4882550000002,0,0,0,0]
[null,"Cotton",431.89350000000002,5500.8315500000008,0,0,0,0,0,0,0,0]
[null,"Turmeric",295.39999999999998,1858.5879199999999,190.43,1078.1277200000002,1.78,10.63833,28.64,168.09714,17.38,99.508939999999996]
[null,"Cotton BSE",423.30340000000001,4731.1464800000003,0,0,43.812400000000004,486.36452000000003,0,0,0,0]
[null,"Soybean",150.77000000000001,622.89708999999993,0,0,40.15,161.29748000000001,0,0,0,0]
[null,"Castorseed",84.3,359.40201000000002,0,0,20.149999999999999,86.388469999999998,0,0,0,0]
[null,"Chana",83.13000000000001,369.69527999999997,0,0,19.61,87.587280000000007,0,0,0,0]
[null,"Cotton29",83.325500000000005,850.271075,150.47975000000002,1423.7491749999999,0,0,0,0,0,0]
[null,"BSE Almond","Na","Na",10.349,321.70452,0,0,2.1190000000000002,68.484669999999994,2.2930000000000001,66.350639999999999]
[null,"Total for 3C",{"$f":"SUM(C51:C60)","v":6825.5124000000014},{"$f":"SUM(D51:D60)","v":36315.944534999995},{"$f":"SUM(E51:E60)","v":819.2287500000001},{"$f":"SUM(F41:F45,F48,F51:F60)","v":4520.0172760000005},{"$f":"SUM(G51:G60)","v":760.95240000000001},3519.7643350000008,30.759,236.58180999999999,19.672999999999998,165.85957999999999,{"$f":"(L61-J61)/J61*100","v":-29.893350634184429},{"$f":"(K61-I61)/I61*100","v":-36.041483793361301}]
["D","Energy",null,null,null,null,null,null,null," "]
[null,"Brent Crude",422.85129604371355,1246.9477400000001,0.35470668499999997,0.57201000000000002,0,0,0,0,0,0]
["C.","NSE"]
[1,"Gold",null,null,null,null,"Na","Na","Na","Na"]
[2,"Silver",null,null,null,null,"Na","Na","Na","Na"]
[null,"Total (NSE)",null,null,null,696.19,"Na","Na","Na","Na",null,696.19]
[null,"Total for 3D",{"$f":"SUM(C63)","v":422.85129604371355},{"$f":"SUM(D63)","v":1246.9477400000001},{"$f":"SUM(E63)","v":0.35470668499999997},0.57201000000000002,0,0,0,0,0,0,null," "]
[null,"Total- BSE Futures (3A+3B+3C+3D)",{"$f":"SUM(C46,C49,C61,C68)","v":7249.7341104437155},{"$f":"SUM(D46,D49,D61,D68)","v":46438.728967000003},{"$f":"SUM(E41:E45,E48,E51:E60,E63)","v":819.62710238499994},{"$f":"SUM(F41:F45,F48,F51:F60,F63)","v":4520.5892860000004},{"$f":"SUM(G46,G49,G61,G68)","v":760.95358799999997},3621.9113970000008,30.759022000000002,247.73299,19.673020999999999,{"$f":"SUM(L46,L49,L61,L63)","v":176.38641999999999},{"$f":"(L69-J69)/J69*100","v":-28.79978560788372},{"$f":"(K69-I69)/I69*100","v":-36.041461266226221}]
[null,"BSE Options"]
["E","Bullion"]
[null,"Gold","Na","Na",8.7116999999999986E-2,44644.051015000005,0,0,2.3033000000000001E-2,11826.02968,1.4066E-2,7137.2456199999997]
[null,"Silver","Na","Na",0.30681000000000003,1947.7501354999999,0,0,9.5640000000000003E-2,592.2499335,6.7680000000000004E-2,423.9934695]
[null,"Silver KG","Na","Na",8.4298000000000012E-2,493.34439420000007,0,0,1.3368E-2,83.551395650000003,1.1561999999999999E-2,73.770913300000004]
[null,"Gold M","Na","Na",0.5861708000000001,292068.48833099997,0,0,8.6231600000000005E-2,43635.56575075,9.010689999999999E-2,46319.197039749997]
[null,"Total for 3E","Na","Na",{"$f":"SUM(E72:E75)","v":1.0643958000000002},{"$f":"SUM(F72:F75)","v":339153.63387569995},0,0,0.21827259999999998,56137.396759900003,0.18341489999999999,53954.207042549999]
[null,"Total - BSE Options (3E)","Na","Na",{"$f":"E76","v":1.0643958000000002},{"$f":"F76","v":339153.63387569995},0,0,0.21827259999999998,56137.396759900003,0.18341489999999999,53954.207042549999,0,0,0,0,0,0,0,0,0]
[{"$f":"'64'!A14","v":"$ indicates as on Nov. 30, 2020"}]
["     Note:","1 Volume for Diamond 1 CT, 0.5CT & 0.3CT are in cents and hence not included in volume (\"000\" tonnes)"]
[null,"2 Conversion factors: Brent Crude Oil (1 Tonne = 7.33 Barrels)"]
["Source : ICEX, BSE and NSE",null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null," "," "]

{"sheet":"74","index":74,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Table 74:  Macro Economic Indicators"]
["I. GDP at Current prices for 2019-20 (₹ crore)#                         ",null,null,null,null,20339849]
["II. Gross Saving as a per cent of Gross national Disposable Income at current market prices in 2018-19!",null,null,null,null,29.7]
["III. Gross Fixed Capital Formation as a per cent of GDP at current market prices in 2019-20#",null,null,null,null,29.8]
["IV.  Monetary and Banking Indicators                  ","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01"]
["Cash Reserve Ratio (per cent)",3,3,3,3,3]
["Repo Rate (per cent)",4,4,4,4,4]
["Money Supply (M3)  (₹ billion)",174906.73,176478.74,177410.65,178048.85,179382]
["Aggregate Deposit (₹ billion)",140204.87,141767.65,142636.74,142926.24,143707]
["Bank Credit (₹ billion)",102194.62,102117.3,102718.57,103388.53,104345]
["V. Interest Rate                        "]
["Call Money Rate (Weighted Average)",3.46,3.43,3.41,3.41,3.1]
["91-Day-Treasury Bill (Primary Yield)",3.3,3.24,3.36,3.36,2.93]
["Base rate (per cent)","7.40/9.00","7.40/9.00","7.40/9.00","7.40/8.80","7.40/8.80"]
["Term Deposit Rate > 1 year (Maximum) ","5.10/5.50","5.00/5.50","4.90/5.50","4.90/5.50","4.90/5.50"]
["VI. Capital Market Indicators (₹ crore)"]
["Equity Cash Turnover (BSE+NSE) ",1428613.7250000001,1375636.4949999999,1293354.004,1156750.075,1407947.89]
["Market Cap-BSE ",14739115.83,15376302.710000001,15524267.369999999,15792249.91,17414859.59]
["Market Cap-NSE ",14629658.609999999,15234206.699999999,15304722.35,15587902.939999999,17271314]
["Net FPI Investment in Equity ",7563,47080,-7783,19541,60357.67]
["VII. Exchange Rate and Reserves"]
["Forex Reserves (USD million)",534568,542013,545638,568494,574821]
["Re/ Dollar",74.77,73.349999999999994,73.73,73.97,73.8]
["Re/Euro",88.87,87.07,86.04,86.97,88.02]
["Forward Premia of USD  6-month",3.8,4.01,3.91,3.89,4.2300000000000004]
["VIII.  Public Borrowing and Inflation Rate (Y-o-Y)"]
["Govt. Market Borrowing-Gross (₹ billion)","4,820^","6,460^","7660^","8760^",9270]
["Wholesale Price Index (2011-12=100) Rate (in per cent)",-0.25,0.41,1.32,1.48,"NA"]
["Consumer Price Index (2012 =100) Rate (in per cent)",6.73,6.69,7.27,7.61,"NA"]
["IX.  Index of Industrial Production (Base year 2011-12 = 100)"]
["General",117.6,116.1,123.2,"NA","NA"]
["Mining",87.4,83,87.6,"NA","NA"]
["Manufacturing",118.2,117.4,125.3,"NA","NA"]
["Electricity",166.3,162.69999999999999,166.4,"NA","NA"]
["X. External Sector Indicators (USD million)"]
["Exports ",23642.85,22700,27580,24890,26509]
["Imports",28469.11,29470,30310,33610,24858]
["Trade Balance",-4826.260000000002,-6770,-2730,-8720,1652]
["Notes: "]
["# Provisional Extimates as per MOSPI press release dated 31.05.2020"]
["^ cumulative figure value of the respective month for 2020-21 "]
["Data for CPI, WPI, IIP and External sector have been compiled based on available information."]
["Source :  RBI, FBIL,  MOSPI,  Ministry of Commerce & Industry, Office of the Economic Adviser."]